Pandas Profiling Report

Dataset statistics

Number of variables	47
Number of observations	356206
Missing cells	3238222
Missing cells (%)	19.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	127.7 MiB
Average record size in memory	376.0 B

Variable types

Numeric	9
Categorical	34
Boolean	2
Unsupported	2

Warnings

`ori` has constant value "CA0371100"	Constant
`agency` has constant value "SD"	Constant
`date_stop` has a high cardinality: 731 distinct values	High cardinality
`time_stop` has a high cardinality: 75362 distinct values	High cardinality
`address_city` has a high cardinality: 51 distinct values	High cardinality
`beat_name` has a high cardinality: 127 distinct values	High cardinality
`highway_exit` has a high cardinality: 2181 distinct values	High cardinality
`address_street` has a high cardinality: 45016 distinct values	High cardinality
`intersection` has a high cardinality: 13841 distinct values	High cardinality
`school_name` has a high cardinality: 99 distinct values	High cardinality
`reason_for_stop_code_text` has a high cardinality: 1566 distinct values	High cardinality
`reason_for_stop_explanation` has a high cardinality: 170749 distinct values	High cardinality
`basis_for_search_explanation` has a high cardinality: 26425 distinct values	High cardinality
`result_text` has a high cardinality: 1260 distinct values	High cardinality
`is_school` is highly correlated with `is_student`	High correlation
`is_student` is highly correlated with `is_school`	High correlation
`gender_nc` is highly correlated with `gender_non_conforming`	High correlation
`gender_non_conforming` is highly correlated with `gender_nc`	High correlation
`is_school` is highly correlated with `is_student`	High correlation
`is_student` is highly correlated with `is_school`	High correlation
`gender_nc` is highly correlated with `gender_non_conforming`	High correlation
`gender_non_conforming` is highly correlated with `gender_nc`	High correlation
`is_school` is highly correlated with `is_student`	High correlation
`is_student` is highly correlated with `is_school`	High correlation
`gender_nc` is highly correlated with `gender_non_conforming`	High correlation
`gender_non_conforming` is highly correlated with `gender_nc`	High correlation
`stop_duration` is highly correlated with `school_name` and 1 other fields	High correlation
`stop_in_response_to_cfs` is highly correlated with `school_name` and 2 other fields	High correlation
`address_city` is highly correlated with `school_name` and 1 other fields	High correlation
`code` is highly correlated with `result` and 4 other fields	High correlation
`result` is highly correlated with `code` and 6 other fields	High correlation
`officer_assignment_key` is highly correlated with `assignment` and 2 other fields	High correlation
`stop_id` is highly correlated with `school_name` and 1 other fields	High correlation
`gender_nc` is highly correlated with `gender_non_conforming` and 1 other fields	High correlation
`beat` is highly correlated with `school_name` and 1 other fields	High correlation
`consented` is highly correlated with `school_name` and 1 other fields	High correlation
`perceived_age` is highly correlated with `school_name` and 1 other fields	High correlation
`perceived_limited_english` is highly correlated with `school_name`	High correlation
`perceived_gender` is highly correlated with `school_name` and 2 other fields	High correlation
`is_student` is highly correlated with `is_school` and 1 other fields	High correlation
`type_of_property_seized` is highly correlated with `code` and 5 other fields	High correlation
`action` is highly correlated with `result` and 5 other fields	High correlation
`assignment` is highly correlated with `officer_assignment_key` and 2 other fields	High correlation
`reason_for_stop` is highly correlated with `result` and 5 other fields	High correlation
`gender_non_conforming` is highly correlated with `gender_nc` and 1 other fields	High correlation
`is_school` is highly correlated with `is_student`	High correlation
`school_name` is highly correlated with `stop_duration` and 23 other fields	High correlation
`landmark` is highly correlated with `stop_duration` and 14 other fields	High correlation
`basis_for_search` is highly correlated with `result` and 5 other fields	High correlation
`basis_for_property_seizure` is highly correlated with `result` and 6 other fields	High correlation
`exp_years` is highly correlated with `school_name` and 1 other fields	High correlation
`perceived_lgbt` is highly correlated with `school_name`	High correlation
`gender` is highly correlated with `perceived_gender` and 2 other fields	High correlation
`gender2` is highly correlated with `gender_nc` and 3 other fields	High correlation
`race` is highly correlated with `school_name` and 1 other fields	High correlation
`reason_for_stop_detail` is highly correlated with `stop_in_response_to_cfs` and 5 other fields	High correlation
`disability` is highly correlated with `school_name` and 1 other fields	High correlation
`highway_exit` has 353273 (99.2%) missing values	Missing
`address_street` has 14608 (4.1%) missing values	Missing
`intersection` has 324647 (91.1%) missing values	Missing
`landmark` has 356163 (> 99.9%) missing values	Missing
`school_name` has 355829 (99.9%) missing values	Missing
`reason_for_stop_code_text` has 20564 (5.8%) missing values	Missing
`reason_for_stop_detail` has 20559 (5.8%) missing values	Missing
`consented` has 350521 (98.4%) missing values	Missing
`basis_for_search` has 282703 (79.4%) missing values	Missing
`basis_for_search_explanation` has 302561 (84.9%) missing values	Missing
`basis_for_property_seizure` has 348426 (97.8%) missing values	Missing
`type_of_property_seized` has 348426 (97.8%) missing values	Missing
`result_text` has 159727 (44.8%) missing values	Missing
`address_block` is highly skewed (γ1 = 307.2329112)	Skewed
`landmark` is uniformly distributed	Uniform
`reason_for_stop_code` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`result_key` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`address_block` has 34105 (9.6%) zeros	Zeros
`code` has 159725 (44.8%) zeros	Zeros

Reproduction

Analysis started	2021-09-13 13:55:43.234778
Analysis finished	2021-09-13 13:58:32.417863
Duration	2 minutes and 49.18 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

stop_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	309924
Distinct (%)	87.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	165513.0811

Minimum	2443
Maximum	324716
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.7 MiB

Quantile statistics

Minimum	2443
5-th percentile	18644
Q1	83999.25
median	166968.5
Q3	245620.75
95-th percentile	309461.75
Maximum	324716
Range	322273
Interquartile range (IQR)	161621.5

Descriptive statistics

Standard deviation	93278.73671
Coefficient of variation (CV)	0.5635731999
Kurtosis	-1.188300054
Mean	165513.0811
Median Absolute Deviation (MAD)	80807.5
Skewness	-0.03088392276
Sum	5.895675255 × 10¹⁰
Variance	8700922723
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
174011	52	< 0.1%
184085	48	< 0.1%
180326	46	< 0.1%
169932	42	< 0.1%
183655	40	< 0.1%
161095	39	< 0.1%
174472	38	< 0.1%
236965	35	< 0.1%
170316	34	< 0.1%
183646	32	< 0.1%
Other values (309914)	355800	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2443	1	< 0.1%
2444	1	< 0.1%
2447	2	< 0.1%
2448	1	< 0.1%
2449	1	< 0.1%
2451	1	< 0.1%
2453	1	< 0.1%
2454	1	< 0.1%
2455	1	< 0.1%
2456	1	< 0.1%

Value	Count	Frequency (%)
324716	1	< 0.1%
324715	1	< 0.1%
324712	3	< 0.1%
324701	1	< 0.1%
324697	1	< 0.1%
324691	1	< 0.1%
324690	1	< 0.1%
324687	1	< 0.1%
324683	1	< 0.1%
324682	1	< 0.1%

date_stop
Categorical

HIGH CARDINALITY

Distinct	731
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

2020-02-12	799
2019-05-23	793
2020-02-11	791
2019-07-06	755
2020-01-16	749
Other values (726)	352319

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3562060
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2018-07-01
2nd row	2018-07-01
3rd row	2018-07-01
4th row	2018-07-01
5th row	2018-07-01

Common Values

Value	Count	Frequency (%)
2020-02-12	799	0.2%
2019-05-23	793	0.2%
2020-02-11	791	0.2%
2019-07-06	755	0.2%
2020-01-16	749	0.2%
2019-10-23	734	0.2%
2019-09-24	733	0.2%
2018-07-03	730	0.2%
2019-08-21	722	0.2%
2018-08-02	719	0.2%
Other values (721)	348681	97.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-02-12	799	0.2%
2019-05-23	793	0.2%
2020-02-11	791	0.2%
2019-07-06	755	0.2%
2020-01-16	749	0.2%
2019-10-23	734	0.2%
2019-09-24	733	0.2%
2018-07-03	730	0.2%
2019-08-21	722	0.2%
2018-08-02	719	0.2%
Other values (721)	348681	97.9%

Most occurring characters

Value	Count	Frequency (%)
0	874623	24.6%
-	712412	20.0%
2	641691	18.0%
1	584745	16.4%
9	251550	7.1%
8	158150	4.4%
3	82920	2.3%
7	69638	2.0%
4	63737	1.8%
5	63731	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2849648	80.0%
Dash Punctuation	712412	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	874623	30.7%
2	641691	22.5%
1	584745	20.5%
9	251550	8.8%
8	158150	5.5%
3	82920	2.9%
7	69638	2.4%
4	63737	2.2%
5	63731	2.2%
6	58863	2.1%

Dash Punctuation

Value	Count	Frequency (%)
-	712412	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3562060	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	874623	24.6%
-	712412	20.0%
2	641691	18.0%
1	584745	16.4%
9	251550	7.1%
8	158150	4.4%
3	82920	2.3%
7	69638	2.0%
4	63737	1.8%
5	63731	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3562060	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	874623	24.6%
-	712412	20.0%
2	641691	18.0%
1	584745	16.4%
9	251550	7.1%
8	158150	4.4%
3	82920	2.3%
7	69638	2.0%
4	63737	1.8%
5	63731	1.8%

time_stop
Categorical

HIGH CARDINALITY

Distinct	75362
Distinct (%)	21.2%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

16:00:00	1023
15:00:00	889
11:00:00	831
10:00:00	827
09:00:00	819
Other values (75357)	351817

Length

Max length	19
Median length	8
Mean length	8.000277929
Min length	8

Characters and Unicode

Total characters	2849747
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16998 ?
Unique (%)	4.8%

Sample

1st row	00:01:37
2nd row	00:03:34
3rd row	00:05:43
4th row	00:05:43
5th row	00:19:06

Common Values

Value	Count	Frequency (%)
16:00:00	1023	0.3%
15:00:00	889	0.2%
11:00:00	831	0.2%
10:00:00	827	0.2%
09:00:00	819	0.2%
17:00:00	808	0.2%
08:00:00	792	0.2%
15:30:00	784	0.2%
22:00:00	773	0.2%
16:30:00	685	0.2%
Other values (75352)	347975	97.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
16:00:00	1023	0.3%
15:00:00	889	0.2%
11:00:00	831	0.2%
10:00:00	827	0.2%
09:00:00	819	0.2%
17:00:00	808	0.2%
08:00:00	792	0.2%
15:30:00	784	0.2%
22:00:00	773	0.2%
16:30:00	685	0.2%
Other values (75346)	347984	97.7%

Most occurring characters

Value	Count	Frequency (%)
:	712412	25.0%
0	604584	21.2%
1	367409	12.9%
2	255487	9.0%
5	199866	7.0%
3	193422	6.8%
4	170620	6.0%
8	89801	3.2%
7	87398	3.1%
9	86012	3.0%
Other values (3)	82736	2.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2137308	75.0%
Other Punctuation	712412	25.0%
Dash Punctuation	18	< 0.1%
Space Separator	9	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	604584	28.3%
1	367409	17.2%
2	255487	12.0%
5	199866	9.4%
3	193422	9.0%
4	170620	8.0%
8	89801	4.2%
7	87398	4.1%
9	86012	4.0%
6	82709	3.9%

Other Punctuation

Value	Count	Frequency (%)
:	712412	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	18	100.0%

Space Separator

Value	Count	Frequency (%)
	9	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2849747	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
:	712412	25.0%
0	604584	21.2%
1	367409	12.9%
2	255487	9.0%
5	199866	7.0%
3	193422	6.8%
4	170620	6.0%
8	89801	3.2%
7	87398	3.1%
9	86012	3.0%
Other values (3)	82736	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2849747	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
:	712412	25.0%
0	604584	21.2%
1	367409	12.9%
2	255487	9.0%
5	199866	7.0%
3	193422	6.8%
4	170620	6.0%
8	89801	3.2%
7	87398	3.1%
9	86012	3.0%
Other values (3)	82736	2.9%

stop_duration
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	347
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.12754979

Minimum	1
Maximum	1440
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.7 MiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	10
median	15
Q3	25
95-th percentile	120
Maximum	1440
Range	1439
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	49.89945582
Coefficient of variation (CV)	1.77404204
Kurtosis	200.9267233
Mean	28.12754979
Median Absolute Deviation (MAD)	7
Skewness	9.801072454
Sum	10019202
Variance	2489.955691
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	80722	22.7%
15	44719	12.6%
5	41047	11.5%
20	36312	10.2%
30	24646	6.9%
60	14652	4.1%
8	12212	3.4%
120	11204	3.1%
6	11159	3.1%
7	8529	2.4%
Other values (337)	71004	19.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1092	0.3%
2	2683	0.8%
3	2971	0.8%
4	2555	0.7%
5	41047	11.5%
6	11159	3.1%
7	8529	2.4%
8	12212	3.4%
9	3206	0.9%
10	80722	22.7%

Value	Count	Frequency (%)
1440	51	< 0.1%
1422	1	< 0.1%
1419	1	< 0.1%
1400	18	< 0.1%
1351	1	< 0.1%
1350	2	< 0.1%
1345	1	< 0.1%
1338	1	< 0.1%
1330	3	< 0.1%
1301	1	< 0.1%

stop_in_response_to_cfs
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

0	315052
1	41154

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	356206
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	315052	88.4%
1	41154	11.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	315052	88.4%
1	41154	11.6%

Most occurring characters

Value	Count	Frequency (%)
0	315052	88.4%
1	41154	11.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	356206	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	315052	88.4%
1	41154	11.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	356206	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	315052	88.4%
1	41154	11.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	356206	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	315052	88.4%
1	41154	11.6%

address_city
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

SAN DIEGO	350508
SAN YSIDRO	1857
CHULA VISTA	656
NATIONAL CITY	646
EL CAJON	409
Other values (46)	2130

Length

Max length	36
Median length	9
Mean length	9.01588126
Min length	4

Characters and Unicode

Total characters	3211511
Distinct characters	25
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10 ?
Unique (%)	< 0.1%

Sample

1st row	SAN DIEGO
2nd row	SAN DIEGO
3rd row	SAN DIEGO
4th row	SAN DIEGO
5th row	SAN DIEGO

Common Values

Value	Count	Frequency (%)
SAN DIEGO	350508	98.4%
SAN YSIDRO	1857	0.5%
CHULA VISTA	656	0.2%
NATIONAL CITY	646	0.2%
EL CAJON	409	0.1%
LEMON GROVE	360	0.1%
LA MESA	265	0.1%
LA JOLLA	228	0.1%
ESCONDIDO	223	0.1%
SANTEE	212	0.1%
Other values (41)	842	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
san	352533	49.5%
diego	350511	49.3%
ysidro	1857	0.3%
vista	658	0.1%
chula	656	0.1%
city	647	0.1%
national	646	0.1%
la	493	0.1%
cajon	409	0.1%
el	409	0.1%
Other values (57)	2852	0.4%

Most occurring characters

Value	Count	Frequency (%)
A	357649	11.1%
S	356149	11.1%
	355465	11.1%
O	355404	11.1%
N	355344	11.1%
I	355097	11.1%
E	353266	11.0%
D	352997	11.0%
G	351020	10.9%
L	3866	0.1%
Other values (15)	15254	0.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2856043	88.9%
Space Separator	355465	11.1%
Dash Punctuation	3	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	357649	12.5%
S	356149	12.5%
O	355404	12.4%
N	355344	12.4%
I	355097	12.4%
E	353266	12.4%
D	352997	12.4%
G	351020	12.3%
L	3866	0.1%
R	2871	0.1%
Other values (13)	12380	0.4%

Space Separator

Value	Count	Frequency (%)
	355465	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2856043	88.9%
Common	355468	11.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	357649	12.5%
S	356149	12.5%
O	355404	12.4%
N	355344	12.4%
I	355097	12.4%
E	353266	12.4%
D	352997	12.4%
G	351020	12.3%
L	3866	0.1%
R	2871	0.1%
Other values (13)	12380	0.4%

Common

Value	Count	Frequency (%)
	355465	> 99.9%
-	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3211511	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	357649	11.1%
S	356149	11.1%
	355465	11.1%
O	355404	11.1%
N	355344	11.1%
I	355097	11.1%
E	353266	11.0%
D	352997	11.0%
G	351020	10.9%
L	3866	0.1%
Other values (15)	15254	0.5%

beat
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	126
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	509.0492524

Minimum	111
Maximum	999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.7 MiB

Quantile statistics

Minimum	111
5-th percentile	121
Q1	315
median	521
Q3	627
95-th percentile	931
Maximum	999
Range	888
Interquartile range (IQR)	312

Descriptive statistics

Standard deviation	241.5275701
Coefficient of variation (CV)	0.4744679792
Kurtosis	-0.7689366337
Mean	509.0492524
Median Absolute Deviation (MAD)	193
Skewness	-0.09464900063
Sum	181326398
Variance	58335.56713
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
521	29119	8.2%
122	22763	6.4%
611	13630	3.8%
524	9670	2.7%
512	9647	2.7%
712	9206	2.6%
813	8780	2.5%
627	8067	2.3%
614	7933	2.2%
313	7794	2.2%
Other values (116)	229597	64.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
111	4189	1.2%
112	1434	0.4%
113	1338	0.4%
114	3225	0.9%
115	3740	1.0%
116	3814	1.1%
121	7741	2.2%
122	22763	6.4%
123	4283	1.2%
124	3539	1.0%

Value	Count	Frequency (%)
999	7690	2.2%
937	814	0.2%
936	270	0.1%
935	621	0.2%
934	4407	1.2%
933	1384	0.4%
932	349	0.1%
931	2927	0.8%
841	608	0.2%
839	948	0.3%

beat_name
Categorical

HIGH CARDINALITY

Distinct	127
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

East Village 521	29119
Pacific Beach 122	22763
Midway District 611	13630
Core-Columbia 524	9670
Logan Heights 512	9647
Other values (122)	271377

Length

Max length	25
Median length	16
Mean length	15.93640758
Min length	10

Characters and Unicode

Total characters	5676644
Distinct characters	64
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Pacific Beach 122
2nd row	Mission Beach 121
3rd row	El Cerrito 822
4th row	El Cerrito 822
5th row	Ocean Beach 614

Common Values

Value	Count	Frequency (%)
East Village 521	29119	8.2%
Pacific Beach 122	22763	6.4%
Midway District 611	13630	3.8%
Core-Columbia 524	9670	2.7%
Logan Heights 512	9647	2.7%
San Ysidro 712	9206	2.6%
North Park 813	8780	2.5%
Hillcrest 627	8067	2.3%
Ocean Beach 614	7933	2.2%
Kearney Mesa 313	7794	2.2%
Other values (117)	229597	64.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
east	44811	4.3%
beach	38437	3.7%
park	36946	3.6%
village	31791	3.1%
mesa	31005	3.0%
521	29119	2.8%
122	22763	2.2%
pacific	22763	2.2%
mission	22093	2.1%
heights	20500	2.0%
Other values (263)	732552	70.9%

Most occurring characters

Value	Count	Frequency (%)
	676574	11.9%
a	496721	8.8%
i	330103	5.8%
e	328709	5.8%
1	274078	4.8%
l	257350	4.5%
2	243157	4.3%
s	236973	4.2%
r	235903	4.2%
t	228362	4.0%
Other values (54)	2368714	41.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3223309	56.8%
Decimal Number	1068618	18.8%
Uppercase Letter	691872	12.2%
Space Separator	676574	11.9%
Dash Punctuation	9670	0.2%
Other Punctuation	6601	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	496721	15.4%
i	330103	10.2%
e	328709	10.2%
l	257350	8.0%
s	236973	7.4%
r	235903	7.3%
t	228362	7.1%
o	218464	6.8%
n	198600	6.2%
c	138663	4.3%
Other values (16)	553461	17.2%

Uppercase Letter

Value	Count	Frequency (%)
M	91978	13.3%
P	73635	10.6%
B	66713	9.6%
C	64918	9.4%
V	61208	8.8%
E	51799	7.5%
H	43171	6.2%
S	35559	5.1%
L	35469	5.1%
O	22108	3.2%
Other values (14)	145314	21.0%

Decimal Number

Value	Count	Frequency (%)
1	274078	25.6%
2	243157	22.8%
3	129219	12.1%
5	112142	10.5%
4	106678	10.0%
6	71067	6.7%
8	49692	4.7%
7	45057	4.2%
9	37528	3.5%

Other Punctuation

Value	Count	Frequency (%)
/	4393	66.6%
.	1429	21.6%
'	779	11.8%

Space Separator

Value	Count	Frequency (%)
	676574	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	9670	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3915181	69.0%
Common	1761463	31.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	496721	12.7%
i	330103	8.4%
e	328709	8.4%
l	257350	6.6%
s	236973	6.1%
r	235903	6.0%
t	228362	5.8%
o	218464	5.6%
n	198600	5.1%
c	138663	3.5%
Other values (40)	1245333	31.8%

Common

Value	Count	Frequency (%)
	676574	38.4%
1	274078	15.6%
2	243157	13.8%
3	129219	7.3%
5	112142	6.4%
4	106678	6.1%
6	71067	4.0%
8	49692	2.8%
7	45057	2.6%
9	37528	2.1%
Other values (4)	16271	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5676644	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	676574	11.9%
a	496721	8.8%
i	330103	5.8%
e	328709	5.8%
1	274078	4.8%
l	257350	4.5%
2	243157	4.3%
s	236973	4.2%
r	235903	4.2%
t	228362	4.0%
Other values (54)	2368714	41.7%

highway_exit
Categorical

HIGH CARDINALITY
MISSING

Distinct	2181
Distinct (%)	74.4%
Missing	353273
Missing (%)	99.2%
Memory size	2.7 MiB

163 Robinson	27
163 robinson	27
I15 bernardo center	22
I-15 Bernardo Center	20
I-805/SR-54	19
Other values (2176)	2818

Length

Max length	54
Median length	17
Mean length	18.39038527
Min length	2

Characters and Unicode

Total characters	53939
Distinct characters	73
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1886 ?
Unique (%)	64.3%

Sample

1st row	sb 15 @ mercy rd
2nd row	I-15 and carmel mountain
3rd row	I-15 and Bernardo Center
4th row	I-15 and Bernardo Center
5th row	I-15 and Bernardo Center

Common Values

Value	Count	Frequency (%)
163 Robinson	27	< 0.1%
163 robinson	27	< 0.1%
I15 bernardo center	22	< 0.1%
I-15 Bernardo Center	20	< 0.1%
I-805/SR-54	19	< 0.1%
I-805/43RD STREET	17	< 0.1%
I-805/PLAZA BOULEVARD	16	< 0.1%
I15 Bernardo Center	15	< 0.1%
I-5/VIA DE SAN YSIDRO	13	< 0.1%
NORTHBOUND INTERSTATE-15/FRIARS ROAD	12	< 0.1%
Other values (2171)	2745	0.8%
(Missing)	353273	99.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
at	738	6.8%
	455	4.2%
15	433	4.0%
sb	360	3.3%
nb	281	2.6%
i-15	239	2.2%
805	226	2.1%
and	201	1.9%
street	182	1.7%
163	181	1.7%
Other values (852)	7522	69.5%

Most occurring characters

Value	Count	Frequency (%)
	7994	14.8%
5	2377	4.4%
a	2177	4.0%
A	2088	3.9%
E	1908	3.5%
T	1877	3.5%
R	1803	3.3%
r	1685	3.1%
e	1632	3.0%
I	1625	3.0%
Other values (63)	28773	53.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	18911	35.1%
Lowercase Letter	17210	31.9%
Space Separator	7994	14.8%
Decimal Number	7219	13.4%
Other Punctuation	1376	2.6%
Dash Punctuation	1218	2.3%
Open Punctuation	5	< 0.1%
Close Punctuation	5	< 0.1%
Connector Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	2177	12.6%
r	1685	9.8%
e	1632	9.5%
n	1468	8.5%
t	1406	8.2%
o	1342	7.8%
s	1063	6.2%
i	897	5.2%
b	886	5.1%
l	765	4.4%
Other values (16)	3889	22.6%

Uppercase Letter

Value	Count	Frequency (%)
A	2088	11.0%
E	1908	10.1%
T	1877	9.9%
R	1803	9.5%
I	1625	8.6%
S	1442	7.6%
N	1226	6.5%
O	1154	6.1%
B	1149	6.1%
D	695	3.7%
Other values (16)	3944	20.9%

Decimal Number

Value	Count	Frequency (%)
5	2377	32.9%
1	1383	19.2%
0	973	13.5%
8	848	11.7%
6	410	5.7%
3	343	4.8%
4	315	4.4%
9	292	4.0%
2	184	2.5%
7	94	1.3%

Other Punctuation

Value	Count	Frequency (%)
/	997	72.5%
@	322	23.4%
,	23	1.7%
.	20	1.5%
&	12	0.9%
!	2	0.1%

Space Separator

Value	Count	Frequency (%)
	7994	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1218	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	5	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	5	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	36121	67.0%
Common	17818	33.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	2177	6.0%
A	2088	5.8%
E	1908	5.3%
T	1877	5.2%
R	1803	5.0%
r	1685	4.7%
e	1632	4.5%
I	1625	4.5%
n	1468	4.1%
S	1442	4.0%
Other values (42)	18416	51.0%

Common

Value	Count	Frequency (%)
	7994	44.9%
5	2377	13.3%
1	1383	7.8%
-	1218	6.8%
/	997	5.6%
0	973	5.5%
8	848	4.8%
6	410	2.3%
3	343	1.9%
@	322	1.8%
Other values (11)	953	5.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	53939	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	7994	14.8%
5	2377	4.4%
a	2177	4.0%
A	2088	3.9%
E	1908	3.5%
T	1877	3.5%
R	1803	3.3%
r	1685	3.1%
e	1632	3.0%
I	1625	3.0%
Other values (63)	28773	53.3%

address_street
Categorical

HIGH CARDINALITY
MISSING

Distinct	45016
Distinct (%)	13.2%
Missing	14608
Missing (%)	4.1%
Memory size	2.7 MiB

imperial	1535
El Cajon Blvd	1516
el cajon blvd	1385
imperial ave	1355
IMPERIAL AVE	1318
Other values (45011)	334489

Length

Max length	100
Median length	10
Mean length	10.5371782
Min length	1

Characters and Unicode

Total characters	3599479
Distinct characters	80
Distinct categories	10 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24391 ?
Unique (%)	7.1%

Sample

1st row	Grand Avenue
2nd row	NOBEL DRIVE
3rd row	59th Street
4th row	59th Street
5th row	NIAGARA AVE

Common Values

Value	Count	Frequency (%)
imperial	1535	0.4%
El Cajon Blvd	1516	0.4%
el cajon blvd	1385	0.4%
imperial ave	1355	0.4%
IMPERIAL AVE	1318	0.4%
garnet	1174	0.3%
university	1100	0.3%
commercial	1080	0.3%
Imperial Ave	1067	0.3%
university ave	1014	0.3%
Other values (45006)	329054	92.4%
(Missing)	14608	4.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ave	41878	6.3%
st	34275	5.1%
street	32824	4.9%
blvd	21740	3.3%
avenue	15558	2.3%
rd	11548	1.7%
mission	10898	1.6%
dr	10819	1.6%
imperial	9415	1.4%
road	8628	1.3%
Other values (9886)	470444	70.4%

Most occurring characters

Value	Count	Frequency (%)
	348443	9.7%
e	254798	7.1%
a	217775	6.1%
t	179297	5.0%
r	173302	4.8%
A	138706	3.9%
n	137139	3.8%
o	126115	3.5%
i	124213	3.5%
l	113883	3.2%
Other values (70)	1785808	49.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1988862	55.3%
Uppercase Letter	1161615	32.3%
Space Separator	348443	9.7%
Decimal Number	89892	2.5%
Other Punctuation	8992	0.2%
Dash Punctuation	1406	< 0.1%
Open Punctuation	115	< 0.1%
Close Punctuation	112	< 0.1%
Modifier Symbol	40	< 0.1%
Math Symbol	2	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	138706	11.9%
E	113500	9.8%
R	97596	8.4%
S	96225	8.3%
T	74721	6.4%
N	65942	5.7%
I	65383	5.6%
O	60555	5.2%
L	60499	5.2%
D	53771	4.6%
Other values (16)	334717	28.8%

Lowercase Letter

Value	Count	Frequency (%)
e	254798	12.8%
a	217775	10.9%
t	179297	9.0%
r	173302	8.7%
n	137139	6.9%
o	126115	6.3%
i	124213	6.2%
l	113883	5.7%
s	112033	5.6%
v	84913	4.3%
Other values (16)	465394	23.4%

Other Punctuation

Value	Count	Frequency (%)
.	7333	81.6%
/	1075	12.0%
#	196	2.2%
&	183	2.0%
'	78	0.9%
@	55	0.6%
,	47	0.5%
:	14	0.2%
;	6	0.1%
"	4	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	18235	20.3%
5	12989	14.4%
4	12448	13.8%
3	9158	10.2%
0	9137	10.2%
6	8488	9.4%
7	6601	7.3%
2	6229	6.9%
8	3828	4.3%
9	2779	3.1%

Open Punctuation

Value	Count	Frequency (%)
(	113	98.3%
[	2	1.7%

Space Separator

Value	Count	Frequency (%)
	348443	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1406	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	112	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	40	100.0%

Math Symbol

Value	Count	Frequency (%)
=	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3150477	87.5%
Common	449002	12.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	254798	8.1%
a	217775	6.9%
t	179297	5.7%
r	173302	5.5%
A	138706	4.4%
n	137139	4.4%
o	126115	4.0%
i	124213	3.9%
l	113883	3.6%
E	113500	3.6%
Other values (42)	1571749	49.9%

Common

Value	Count	Frequency (%)
	348443	77.6%
1	18235	4.1%
5	12989	2.9%
4	12448	2.8%
3	9158	2.0%
0	9137	2.0%
6	8488	1.9%
.	7333	1.6%
7	6601	1.5%
2	6229	1.4%
Other values (18)	9941	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3599479	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	348443	9.7%
e	254798	7.1%
a	217775	6.1%
t	179297	5.0%
r	173302	4.8%
A	138706	3.9%
n	137139	3.8%
o	126115	3.5%
i	124213	3.5%
l	113883	3.2%
Other values (70)	1785808	49.6%

intersection
Categorical

HIGH CARDINALITY
MISSING

Distinct	13841
Distinct (%)	43.9%
Missing	324647
Missing (%)	91.1%
Memory size	2.7 MiB

CAMINO DE LA PLAZA/ CAMIONES WAY	170
BROADWAY	138
G Street	131
w ash	130
I-15	112
Other values (13836)	30878

Length

Max length	77
Median length	12
Mean length	14.14087899
Min length	1

Characters and Unicode

Total characters	446272
Distinct characters	78
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10011 ?
Unique (%)	31.7%

Sample

1st row	I-5
2nd row	space theater way
3rd row	torrey pines rd
4th row	TOCAYO AVENUE
5th row	Mission Blvd

Common Values

Value	Count	Frequency (%)
CAMINO DE LA PLAZA/ CAMIONES WAY	170	< 0.1%
BROADWAY	138	< 0.1%
G Street	131	< 0.1%
w ash	130	< 0.1%
I-15	112	< 0.1%
imperial	98	< 0.1%
torrey pines	84	< 0.1%
805	76	< 0.1%
MARKET	74	< 0.1%
MISSION	72	< 0.1%
Other values (13831)	30474	8.6%
(Missing)	324647	91.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
st	2762	3.3%
and	2544	3.1%
	2509	3.0%
ave	2505	3.0%
street	1884	2.3%
beach	1605	1.9%
mission	1590	1.9%
rd	1140	1.4%
blvd	1096	1.3%
dr	1030	1.2%
Other values (4245)	63949	77.4%

Most occurring characters

Value	Count	Frequency (%)
	53395	12.0%
A	22325	5.0%
a	21963	4.9%
e	20971	4.7%
E	16811	3.8%
r	15782	3.5%
n	14017	3.1%
t	13587	3.0%
R	13388	3.0%
S	13222	3.0%
Other values (68)	240811	54.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	184104	41.3%
Uppercase Letter	180758	40.5%
Space Separator	53395	12.0%
Decimal Number	17420	3.9%
Other Punctuation	8826	2.0%
Dash Punctuation	1760	0.4%
Open Punctuation	4	< 0.1%
Close Punctuation	4	< 0.1%
Math Symbol	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	22325	12.4%
E	16811	9.3%
R	13388	7.4%
S	13222	7.3%
I	13116	7.3%
N	11591	6.4%
O	10711	5.9%
T	9025	5.0%
C	8856	4.9%
L	8428	4.7%
Other values (16)	53285	29.5%

Lowercase Letter

Value	Count	Frequency (%)
a	21963	11.9%
e	20971	11.4%
r	15782	8.6%
n	14017	7.6%
t	13587	7.4%
o	12365	6.7%
i	11829	6.4%
s	10729	5.8%
l	9584	5.2%
d	8853	4.8%
Other values (16)	44424	24.1%

Other Punctuation

Value	Count	Frequency (%)
/	7826	88.7%
.	477	5.4%
&	173	2.0%
@	160	1.8%
,	113	1.3%
'	65	0.7%
!	5	0.1%
;	2	< 0.1%
#	2	< 0.1%
:	2	< 0.1%

Decimal Number

Value	Count	Frequency (%)
5	5246	30.1%
1	3215	18.5%
0	2231	12.8%
8	1751	10.1%
6	1056	6.1%
4	1053	6.0%
3	1027	5.9%
2	879	5.0%
9	540	3.1%
7	422	2.4%

Dash Punctuation

Value	Count	Frequency (%)
-	1760	100.0%

Space Separator

Value	Count	Frequency (%)
	53395	100.0%

Math Symbol

Value	Count	Frequency (%)
=	1	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	4	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	364862	81.8%
Common	81410	18.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	22325	6.1%
a	21963	6.0%
e	20971	5.7%
E	16811	4.6%
r	15782	4.3%
n	14017	3.8%
t	13587	3.7%
R	13388	3.7%
S	13222	3.6%
I	13116	3.6%
Other values (42)	199680	54.7%

Common

Value	Count	Frequency (%)
	53395	65.6%
/	7826	9.6%
5	5246	6.4%
1	3215	3.9%
0	2231	2.7%
-	1760	2.2%
8	1751	2.2%
6	1056	1.3%
4	1053	1.3%
3	1027	1.3%
Other values (16)	2850	3.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	446272	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	53395	12.0%
A	22325	5.0%
a	21963	4.9%
e	20971	4.7%
E	16811	3.8%
r	15782	3.5%
n	14017	3.1%
t	13587	3.0%
R	13388	3.0%
S	13222	3.0%
Other values (68)	240811	54.0%

address_block
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	280
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5595.259204

Minimum	0
Maximum	99999900
Zeros	34105
Zeros (%)	9.6%
Negative	0
Negative (%)	0.0%
Memory size	2.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	800
median	2700
Q3	4400
95-th percentile	9200
Maximum	99999900
Range	99999900
Interquartile range (IQR)	3600

Descriptive statistics

Standard deviation	265547.7147
Coefficient of variation (CV)	47.45941252
Kurtosis	113168.6982
Mean	5595.259204
Median Absolute Deviation (MAD)	1800
Skewness	307.2329112
Sum	1993064900
Variance	7.051558878 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	34105	9.6%
100	10861	3.0%
700	8900	2.5%
3000	8391	2.4%
4000	7847	2.2%
1000	7466	2.1%
800	7385	2.1%
500	7311	2.1%
4300	6649	1.9%
4200	6601	1.9%
Other values (270)	250690	70.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34105	9.6%
100	10861	3.0%
200	6290	1.8%
300	6067	1.7%
400	5327	1.5%
500	7311	2.1%
600	5712	1.6%
700	8900	2.5%
800	7385	2.1%
900	5737	1.6%

Value	Count	Frequency (%)
99999900	2	< 0.1%
9999900	49	< 0.1%
8004000	1	< 0.1%
999900	157	< 0.1%
520000	1	< 0.1%
133000	1	< 0.1%
122000	2	< 0.1%
121700	1	< 0.1%
121100	1	< 0.1%
120100	1	< 0.1%

landmark
Categorical

HIGH CORRELATION
MISSING
UNIFORM

Distinct	37
Distinct (%)	86.0%
Missing	356163
Missing (%)	> 99.9%
Memory size	2.7 MiB

fiesta island bay	4
North Cove Park Pacific beach	2
Montgomery-Waller Recreation Center	2
:Fiesta Island Bay	2
5N at Genesee Ave	1
Other values (32)	32

Length

Max length	41
Median length	17
Mean length	19.27906977
Min length	8

Characters and Unicode

Total characters	829
Distinct characters	59
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	33 ?
Unique (%)	76.7%

Sample

1st row	Fiesta Island
2nd row	Crown Point
3rd row	fiesta island bay
4th row	fiesta island bay
5th row	:Fiesta Island Bay

Common Values

Value	Count	Frequency (%)
fiesta island bay	4	< 0.1%
North Cove Park Pacific beach	2	< 0.1%
Montgomery-Waller Recreation Center	2	< 0.1%
:Fiesta Island Bay	2	< 0.1%
5N at Genesee Ave	1	< 0.1%
ON TROLLEY IN SANTEE	1	< 0.1%
Ski beach	1	< 0.1%
Fiesta Island Bay	1	< 0.1%
sr905 / i805	1	< 0.1%
BALBOA PARK - SPANISH VILLAGE	1	< 0.1%
Other values (27)	27	< 0.1%
(Missing)	356163	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	8	5.3%
island	8	5.3%
at	8	5.3%
fiesta	8	5.3%
bay	7	4.6%
sb	5	3.3%
park	5	3.3%
drive	4	2.6%
cove	4	2.6%
i-15	4	2.6%
Other values (65)	90	59.6%

Most occurring characters

Value	Count	Frequency (%)
	108	13.0%
a	46	5.5%
e	39	4.7%
E	34	4.1%
A	34	4.1%
R	32	3.9%
I	29	3.5%
T	28	3.4%
t	26	3.1%
i	25	3.0%
Other values (49)	428	51.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	325	39.2%
Uppercase Letter	323	39.0%
Space Separator	108	13.0%
Decimal Number	50	6.0%
Dash Punctuation	12	1.4%
Other Punctuation	11	1.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	34	10.5%
A	34	10.5%
R	32	9.9%
I	29	9.0%
T	28	8.7%
S	22	6.8%
N	22	6.8%
O	20	6.2%
B	19	5.9%
D	12	3.7%
Other values (12)	71	22.0%

Lowercase Letter

Value	Count	Frequency (%)
a	46	14.2%
e	39	12.0%
t	26	8.0%
i	25	7.7%
n	22	6.8%
r	22	6.8%
s	21	6.5%
o	21	6.5%
l	16	4.9%
d	14	4.3%
Other values (12)	73	22.5%

Decimal Number

Value	Count	Frequency (%)
5	17	34.0%
1	10	20.0%
9	5	10.0%
0	4	8.0%
8	3	6.0%
6	3	6.0%
4	3	6.0%
3	2	4.0%
2	2	4.0%
7	1	2.0%

Other Punctuation

Value	Count	Frequency (%)
/	5	45.5%
@	4	36.4%
:	2	18.2%

Space Separator

Value	Count	Frequency (%)
	108	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	12	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	648	78.2%
Common	181	21.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	46	7.1%
e	39	6.0%
E	34	5.2%
A	34	5.2%
R	32	4.9%
I	29	4.5%
T	28	4.3%
t	26	4.0%
i	25	3.9%
n	22	3.4%
Other values (34)	333	51.4%

Common

Value	Count	Frequency (%)
	108	59.7%
5	17	9.4%
-	12	6.6%
1	10	5.5%
/	5	2.8%
9	5	2.8%
0	4	2.2%
@	4	2.2%
8	3	1.7%
6	3	1.7%
Other values (5)	10	5.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	829	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	108	13.0%
a	46	5.5%
e	39	4.7%
E	34	4.1%
A	34	4.1%
R	32	3.9%
I	29	3.5%
T	28	3.4%
t	26	3.1%
i	25	3.0%
Other values (49)	428	51.6%

is_school
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

0	355829
1	377

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	356206
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	355829	99.9%
1	377	0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	355829	99.9%
1	377	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	355829	99.9%
1	377	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	356206	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	355829	99.9%
1	377	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	356206	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	355829	99.9%
1	377	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	356206	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	355829	99.9%
1	377	0.1%

school_name
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING

Distinct	99
Distinct (%)	26.3%
Missing	355829
Missing (%)	99.9%
Memory size	2.7 MiB

Ibarra Elementary (San Diego Unified) 37683380108290	38
Rancho Bernardo High (Poway Unified) 37682963730819	24
Del Norte High (Poway Unified) 37682960118935	17
Montgomery Senior High (Sweetwater Union High) 37684113738234	17
Torrey Pines High (San Dieguito Union High) 37683463730033	16
Other values (94)	265

Length

Max length	69
Median length	52
Mean length	53.08488064
Min length	35

Characters and Unicode

Total characters	20013
Distinct characters	65
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	39 ?
Unique (%)	10.3%

Sample

1st row	Rancho Bernardo High (Poway Unified) 37682963730819
2nd row	Rancho Bernardo High (Poway Unified) 37682963730819
3rd row	Cherokee Point Elementary (San Diego Unified) 37683380108282
4th row	Rancho Bernardo High (Poway Unified) 37682963730819
5th row	Rancho Bernardo High (Poway Unified) 37682963730819

Common Values

Value	Count	Frequency (%)
Ibarra Elementary (San Diego Unified) 37683380108290	38	< 0.1%
Rancho Bernardo High (Poway Unified) 37682963730819	24	< 0.1%
Del Norte High (Poway Unified) 37682960118935	17	< 0.1%
Montgomery Senior High (Sweetwater Union High) 37684113738234	17	< 0.1%
Torrey Pines High (San Dieguito Union High) 37683463730033	16	< 0.1%
The O'Farrell Charter (San Diego Unified) 37683386061964	14	< 0.1%
San Ysidro Middle (San Ysidro Elementary) 37683796098453	14	< 0.1%
Canyon Crest Academy (San Dieguito Union High) 37683460106328	10	< 0.1%
San Ysidro High (Sweetwater Union High) 37684113731502	10	< 0.1%
Mt. Carmel High (Poway Unified) 37682963730074	9	< 0.1%
Other values (89)	208	0.1%
(Missing)	355829	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
san	256	10.6%
unified	253	10.5%
high	201	8.3%
diego	166	6.9%
elementary	155	6.4%
poway	87	3.6%
union	82	3.4%
middle	68	2.8%
ysidro	55	2.3%
sweetwater	43	1.8%
Other values (236)	1053	43.5%

Most occurring characters

Value	Count	Frequency (%)
	2048	10.2%
e	1351	6.8%
i	1330	6.6%
3	1201	6.0%
n	1086	5.4%
a	949	4.7%
6	789	3.9%
8	747	3.7%
o	712	3.6%
r	707	3.5%
Other values (55)	9093	45.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9795	48.9%
Decimal Number	5289	26.4%
Uppercase Letter	2085	10.4%
Space Separator	2048	10.2%
Open Punctuation	377	1.9%
Close Punctuation	377	1.9%
Other Punctuation	26	0.1%
Dash Punctuation	16	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	372	17.8%
U	337	16.2%
D	230	11.0%
H	224	10.7%
E	164	7.9%
P	136	6.5%
M	132	6.3%
C	84	4.0%
B	60	2.9%
Y	55	2.6%
Other values (14)	291	14.0%

Lowercase Letter

Value	Count	Frequency (%)
e	1351	13.8%
i	1330	13.6%
n	1086	11.1%
a	949	9.7%
o	712	7.3%
r	707	7.2%
d	531	5.4%
t	469	4.8%
g	448	4.6%
l	396	4.0%
Other values (14)	1816	18.5%

Decimal Number

Value	Count	Frequency (%)
3	1201	22.7%
6	789	14.9%
8	747	14.1%
7	621	11.7%
0	594	11.2%
1	403	7.6%
9	364	6.9%
2	250	4.7%
4	187	3.5%
5	133	2.5%

Other Punctuation

Value	Count	Frequency (%)
'	14	53.8%
.	10	38.5%
/	2	7.7%

Space Separator

Value	Count	Frequency (%)
	2048	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	377	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	377	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	16	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11880	59.4%
Common	8133	40.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1351	11.4%
i	1330	11.2%
n	1086	9.1%
a	949	8.0%
o	712	6.0%
r	707	6.0%
d	531	4.5%
t	469	3.9%
g	448	3.8%
l	396	3.3%
Other values (38)	3901	32.8%

Common

Value	Count	Frequency (%)
	2048	25.2%
3	1201	14.8%
6	789	9.7%
8	747	9.2%
7	621	7.6%
0	594	7.3%
1	403	5.0%
(	377	4.6%
)	377	4.6%
9	364	4.5%
Other values (7)	612	7.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20013	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	2048	10.2%
e	1351	6.8%
i	1330	6.6%
3	1201	6.0%
n	1086	5.4%
a	949	4.7%
6	789	3.9%
8	747	3.7%
o	712	3.6%
r	707	3.5%
Other values (55)	9093	45.4%

ori
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

CA0371100	356206

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	3205854
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CA0371100
2nd row	CA0371100
3rd row	CA0371100
4th row	CA0371100
5th row	CA0371100

Common Values

Value	Count	Frequency (%)
CA0371100	356206	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
ca0371100	356206	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	1068618	33.3%
1	712412	22.2%
C	356206	11.1%
A	356206	11.1%
3	356206	11.1%
7	356206	11.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2493442	77.8%
Uppercase Letter	712412	22.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1068618	42.9%
1	712412	28.6%
3	356206	14.3%
7	356206	14.3%

Uppercase Letter

Value	Count	Frequency (%)
C	356206	50.0%
A	356206	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2493442	77.8%
Latin	712412	22.2%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1068618	42.9%
1	712412	28.6%
3	356206	14.3%
7	356206	14.3%

Latin

Value	Count	Frequency (%)
C	356206	50.0%
A	356206	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3205854	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1068618	33.3%
1	712412	22.2%
C	356206	11.1%
A	356206	11.1%
3	356206	11.1%
7	356206	11.1%

agency
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

SD	356206

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	712412
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SD
2nd row	SD
3rd row	SD
4th row	SD
5th row	SD

Common Values

Value	Count	Frequency (%)
SD	356206	100.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
sd	356206	100.0%

Most occurring characters

Value	Count	Frequency (%)
S	356206	50.0%
D	356206	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	712412	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	356206	50.0%
D	356206	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	712412	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	356206	50.0%
D	356206	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	712412	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	356206	50.0%
D	356206	50.0%

officer_assignment_key
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.520286014

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.7 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	8
Maximum	10
Range	9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.973837466
Coefficient of variation (CV)	1.298332977
Kurtosis	12.73052062
Mean	1.520286014
Median Absolute Deviation (MAD)	0
Skewness	3.790244382
Sum	541535
Variance	3.896034343
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	326018	91.5%
10	13466	3.8%
2	7745	2.2%
9	3907	1.1%
7	1933	0.5%
6	766	0.2%
4	749	0.2%
5	705	0.2%
8	561	0.2%
3	356	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	326018	91.5%
2	7745	2.2%
3	356	0.1%
4	749	0.2%
5	705	0.2%
6	766	0.2%
7	1933	0.5%
8	561	0.2%
9	3907	1.1%
10	13466	3.8%

Value	Count	Frequency (%)
10	13466	3.8%
9	3907	1.1%
8	561	0.2%
7	1933	0.5%
6	766	0.2%
5	705	0.2%
4	749	0.2%
3	356	0.1%
2	7745	2.2%
1	326018	91.5%

assignment
Categorical

HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

Patrol, traffic enforcement, field operations	326018
Other	13466
Gang enforcement	7745
Investigative/detective	3907
Task force	1933
Other values (5)	3137

Length

Max length	78
Median length	45
Mean length	42.29938575
Min length	5

Characters and Unicode

Total characters	15067295
Distinct characters	39
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Patrol, traffic enforcement, field operations
2nd row	Patrol, traffic enforcement, field operations
3rd row	Other
4th row	Other
5th row	Patrol, traffic enforcement, field operations

Common Values

Value	Count	Frequency (%)
Patrol, traffic enforcement, field operations	326018	91.5%
Other	13466	3.8%
Gang enforcement	7745	2.2%
Investigative/detective	3907	1.1%
Task force	1933	0.5%
Narcotics/vice	766	0.2%
Special events	749	0.2%
Roadblock or DUI sobriety checkpoint	705	0.2%
K1-12 public school inlcuding school resource officer or school police officer	561	0.2%
Compliance check	356	0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
enforcement	333763	19.9%
traffic	326018	19.4%
patrol	326018	19.4%
field	326018	19.4%
operations	326018	19.4%
other	13466	0.8%
gang	7745	0.5%
investigative/detective	3907	0.2%
force	1933	0.1%
task	1933	0.1%
Other values (17)	12672	0.8%

Most occurring characters

Value	Count	Frequency (%)
e	1696199	11.3%
t	1343836	8.9%
r	1332197	8.8%
o	1324568	8.8%
	1323285	8.8%
f	1315994	8.7%
n	1008128	6.7%
i	997188	6.6%
a	994215	6.6%
c	676900	4.5%
Other values (29)	3054785	20.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12726736	84.5%
Space Separator	1323285	8.8%
Other Punctuation	656709	4.4%
Uppercase Letter	358321	2.4%
Decimal Number	1683	< 0.1%
Dash Punctuation	561	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1696199	13.3%
t	1343836	10.6%
r	1332197	10.5%
o	1324568	10.4%
f	1315994	10.3%
n	1008128	7.9%
i	997188	7.8%
a	994215	7.8%
c	676900	5.3%
l	657212	5.2%
Other values (11)	1380299	10.8%

Uppercase Letter

Value	Count	Frequency (%)
P	326018	91.0%
O	13466	3.8%
G	7745	2.2%
I	4612	1.3%
T	1933	0.5%
N	766	0.2%
S	749	0.2%
R	705	0.2%
D	705	0.2%
U	705	0.2%
Other values (2)	917	0.3%

Other Punctuation

Value	Count	Frequency (%)
,	652036	99.3%
/	4673	0.7%

Decimal Number

Value	Count	Frequency (%)
1	1122	66.7%
2	561	33.3%

Space Separator

Value	Count	Frequency (%)
	1323285	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	561	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13085057	86.8%
Common	1982238	13.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1696199	13.0%
t	1343836	10.3%
r	1332197	10.2%
o	1324568	10.1%
f	1315994	10.1%
n	1008128	7.7%
i	997188	7.6%
a	994215	7.6%
c	676900	5.2%
l	657212	5.0%
Other values (23)	1738620	13.3%

Common

Value	Count	Frequency (%)
	1323285	66.8%
,	652036	32.9%
/	4673	0.2%
1	1122	0.1%
-	561	< 0.1%
2	561	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15067295	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1696199	11.3%
t	1343836	8.9%
r	1332197	8.8%
o	1324568	8.8%
	1323285	8.8%
f	1315994	8.7%
n	1008128	6.7%
i	997188	6.6%
a	994215	6.6%
c	676900	4.5%
Other values (29)	3054785	20.3%

exp_years
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	41
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.805994284

Minimum	1
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.7 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	4
Q3	10
95-th percentile	23
Maximum	50
Range	49
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	7.39668262
Coefficient of variation (CV)	1.086789426
Kurtosis	1.820133028
Mean	6.805994284
Median Absolute Deviation (MAD)	3
Skewness	1.522281549
Sum	2424336
Variance	54.71091377
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
1	109137	30.6%
3	33755	9.5%
2	31693	8.9%
5	27239	7.6%
4	26442	7.4%
10	15890	4.5%
9	11058	3.1%
18	10613	3.0%
11	9836	2.8%
6	8625	2.4%
Other values (31)	71918	20.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	109137	30.6%
2	31693	8.9%
3	33755	9.5%
4	26442	7.4%
5	27239	7.6%
6	8625	2.4%
7	3831	1.1%
8	4681	1.3%
9	11058	3.1%
10	15890	4.5%

Value	Count	Frequency (%)
50	6	< 0.1%
49	14	< 0.1%
48	222	0.1%
45	36	< 0.1%
37	2	< 0.1%
36	2	< 0.1%
35	1	< 0.1%
34	2	< 0.1%
33	18	< 0.1%
32	310	0.1%

pid
Real number (ℝ_≥0)

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.253912062

Minimum	1
Maximum	52
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.7 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	52
Range	51
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.231543519
Coefficient of variation (CV)	0.9821609952
Kurtosis	369.2604304
Mean	1.253912062
Median Absolute Deviation (MAD)	0
Skewness	15.60945713
Sum	446651
Variance	1.516699439
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	309922	87.0%
2	30762	8.6%
3	8275	2.3%
4	3142	0.9%
5	1379	0.4%
6	739	0.2%
7	411	0.1%
8	276	0.1%
9	194	0.1%
10	156	< 0.1%
Other values (42)	950	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	309922	87.0%
2	30762	8.6%
3	8275	2.3%
4	3142	0.9%
5	1379	0.4%
6	739	0.2%
7	411	0.1%
8	276	0.1%
9	194	0.1%
10	156	< 0.1%

Value	Count	Frequency (%)
52	1	< 0.1%
51	1	< 0.1%
50	1	< 0.1%
49	1	< 0.1%
48	2	< 0.1%
47	2	< 0.1%
46	3	< 0.1%
45	3	< 0.1%
44	3	< 0.1%
43	3	< 0.1%

is_student
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

0	355982
1	224

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	356206
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	355982	99.9%
1	224	0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	355982	99.9%
1	224	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	355982	99.9%
1	224	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	356206	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	355982	99.9%
1	224	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	356206	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	355982	99.9%
1	224	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	356206	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	355982	99.9%
1	224	0.1%

perceived_limited_english
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

0	347456
1	8750

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	356206
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	347456	97.5%
1	8750	2.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	347456	97.5%
1	8750	2.5%

Most occurring characters

Value	Count	Frequency (%)
0	347456	97.5%
1	8750	2.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	356206	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	347456	97.5%
1	8750	2.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	356206	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	347456	97.5%
1	8750	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	356206	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	347456	97.5%
1	8750	2.5%

perceived_age
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	109
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.39630439

Minimum	1
Maximum	120
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.7 MiB

Quantile statistics

Minimum	1
5-th percentile	20
Q1	26
median	35
Q3	48
95-th percentile	60
Maximum	120
Range	119
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	13.46826227
Coefficient of variation (CV)	0.3601495519
Kurtosis	-0.233981078
Mean	37.39630439
Median Absolute Deviation (MAD)	10
Skewness	0.573057818
Sum	13320788
Variance	181.3940885
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	50286	14.1%
40	36949	10.4%
25	36237	10.2%
50	32814	9.2%
35	28417	8.0%
45	21130	5.9%
60	18828	5.3%
20	17182	4.8%
55	14046	3.9%
21	6171	1.7%
Other values (99)	94146	26.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	10	< 0.1%
2	8	< 0.1%
3	4	< 0.1%
4	13	< 0.1%
5	54	< 0.1%
6	23	< 0.1%
7	36	< 0.1%
8	64	< 0.1%
9	35	< 0.1%
10	275	0.1%

Value	Count	Frequency (%)
120	8	< 0.1%
118	1	< 0.1%
116	2	< 0.1%
115	1	< 0.1%
110	1	< 0.1%
105	1	< 0.1%
103	1	< 0.1%
102	1	< 0.1%
101	1	< 0.1%
100	18	< 0.1%

gender2
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

1	259302
2	95816
3	569
4	415
0	104

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	356206
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	2
5th row	1

Common Values

Value	Count	Frequency (%)
1	259302	72.8%
2	95816	26.9%
3	569	0.2%
4	415	0.1%
0	104	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	259302	72.8%
2	95816	26.9%
3	569	0.2%
4	415	0.1%
0	104	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	259302	72.8%
2	95816	26.9%
3	569	0.2%
4	415	0.1%
0	104	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	356206	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	259302	72.8%
2	95816	26.9%
3	569	0.2%
4	415	0.1%
0	104	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	356206	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	259302	72.8%
2	95816	26.9%
3	569	0.2%
4	415	0.1%
0	104	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	356206	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	259302	72.8%
2	95816	26.9%
3	569	0.2%
4	415	0.1%
0	104	< 0.1%

perceived_gender
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	104
Missing (%)	< 0.1%
Memory size	2.7 MiB

Male	259302
Female	95816
Transgender man/boy	569
Transgender woman/girl	415

Length

Max length	22
Median length	4
Mean length	4.583082937
Min length	4

Characters and Unicode

Total characters	1632045
Distinct characters	19
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Male
2nd row	Male
3rd row	Male
4th row	Female
5th row	Male

Common Values

Value	Count	Frequency (%)
Male	259302	72.8%
Female	95816	26.9%
Transgender man/boy	569	0.2%
Transgender woman/girl	415	0.1%
(Missing)	104	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
male	259302	72.6%
female	95816	26.8%
transgender	984	0.3%
man/boy	569	0.2%
woman/girl	415	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	452902	27.8%
a	357086	21.9%
l	355533	21.8%
M	259302	15.9%
m	96800	5.9%
F	95816	5.9%
n	2952	0.2%
r	2383	0.1%
g	1399	0.1%
T	984	0.1%
Other values (9)	6888	0.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1273975	78.1%
Uppercase Letter	356102	21.8%
Space Separator	984	0.1%
Other Punctuation	984	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	452902	35.6%
a	357086	28.0%
l	355533	27.9%
m	96800	7.6%
n	2952	0.2%
r	2383	0.2%
g	1399	0.1%
s	984	0.1%
d	984	0.1%
o	984	0.1%
Other values (4)	1968	0.2%

Uppercase Letter

Value	Count	Frequency (%)
M	259302	72.8%
F	95816	26.9%
T	984	0.3%

Space Separator

Value	Count	Frequency (%)
	984	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	984	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1630077	99.9%
Common	1968	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	452902	27.8%
a	357086	21.9%
l	355533	21.8%
M	259302	15.9%
m	96800	5.9%
F	95816	5.9%
n	2952	0.2%
r	2383	0.1%
g	1399	0.1%
T	984	0.1%
Other values (7)	4920	0.3%

Common

Value	Count	Frequency (%)
	984	50.0%
/	984	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1632045	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	452902	27.8%
a	357086	21.9%
l	355533	21.8%
M	259302	15.9%
m	96800	5.9%
F	95816	5.9%
n	2952	0.2%
r	2383	0.1%
g	1399	0.1%
T	984	0.1%
Other values (9)	6888	0.4%

gender_nc
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

0	356029
5	177

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	356206
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	356029	> 99.9%
5	177	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	356029	> 99.9%
5	177	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	356029	> 99.9%
5	177	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	356206	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	356029	> 99.9%
5	177	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	356206	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	356029	> 99.9%
5	177	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	356206	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	356029	> 99.9%
5	177	< 0.1%

gender_non_conforming
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

0	356029
1	177

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	356206
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	356029	> 99.9%
1	177	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	356029	> 99.9%
1	177	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	356029	> 99.9%
1	177	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	356206	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	356029	> 99.9%
1	177	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	356206	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	356029	> 99.9%
1	177	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	356206	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	356029	> 99.9%
1	177	< 0.1%

gender
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	104
Missing (%)	< 0.1%
Memory size	2.7 MiB

Male	259300
Female	95818
Transgender man/boy	569
Transgender woman/girl	415

Length

Max length	22
Median length	4
Mean length	4.58309417
Min length	4

Characters and Unicode

Total characters	1632049
Distinct characters	19
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Male
2nd row	Male
3rd row	Male
4th row	Female
5th row	Male

Common Values

Value	Count	Frequency (%)
Male	259300	72.8%
Female	95818	26.9%
Transgender man/boy	569	0.2%
Transgender woman/girl	415	0.1%
(Missing)	104	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
male	259300	72.6%
female	95818	26.8%
transgender	984	0.3%
man/boy	569	0.2%
woman/girl	415	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	452904	27.8%
a	357086	21.9%
l	355533	21.8%
M	259300	15.9%
m	96802	5.9%
F	95818	5.9%
n	2952	0.2%
r	2383	0.1%
g	1399	0.1%
T	984	0.1%
Other values (9)	6888	0.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1273979	78.1%
Uppercase Letter	356102	21.8%
Space Separator	984	0.1%
Other Punctuation	984	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	452904	35.6%
a	357086	28.0%
l	355533	27.9%
m	96802	7.6%
n	2952	0.2%
r	2383	0.2%
g	1399	0.1%
s	984	0.1%
d	984	0.1%
o	984	0.1%
Other values (4)	1968	0.2%

Uppercase Letter

Value	Count	Frequency (%)
M	259300	72.8%
F	95818	26.9%
T	984	0.3%

Space Separator

Value	Count	Frequency (%)
	984	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	984	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1630081	99.9%
Common	1968	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	452904	27.8%
a	357086	21.9%
l	355533	21.8%
M	259300	15.9%
m	96802	5.9%
F	95818	5.9%
n	2952	0.2%
r	2383	0.1%
g	1399	0.1%
T	984	0.1%
Other values (7)	4920	0.3%

Common

Value	Count	Frequency (%)
	984	50.0%
/	984	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1632049	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	452904	27.8%
a	357086	21.9%
l	355533	21.8%
M	259300	15.9%
m	96802	5.9%
F	95818	5.9%
n	2952	0.2%
r	2383	0.1%
g	1399	0.1%
T	984	0.1%
Other values (9)	6888	0.4%

perceived_lgbt
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	348.0 KiB

False	346430
True	9776

Common Values
Chart

Value	Count	Frequency (%)
False	346430	97.3%
True	9776	2.7%

race
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

White	152082
Hispanic/Latino/a	102862
Black/African American	71069
Asian	17052
Middle Eastern or South Asian	9415
Other values (2)	3726

Length

Max length	29
Median length	17
Mean length	12.60421217
Min length	5

Characters and Unicode

Total characters	4489696
Distinct characters	31
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	White
2nd row	White
3rd row	Hispanic/Latino/a
4th row	Hispanic/Latino/a
5th row	White

Common Values

Value	Count	Frequency (%)
White	152082	42.7%
Hispanic/Latino/a	102862	28.9%
Black/African American	71069	20.0%
Asian	17052	4.8%
Middle Eastern or South Asian	9415	2.6%
Pacific Islander	2929	0.8%
Native American	797	0.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
white	152082	32.5%
hispanic/latino/a	102862	21.9%
american	71866	15.3%
black/african	71069	15.2%
asian	26467	5.6%
south	9415	2.0%
middle	9415	2.0%
or	9415	2.0%
eastern	9415	2.0%
islander	2929	0.6%
Other values (2)	3726	0.8%

Most occurring characters

Value	Count	Frequency (%)
i	646140	14.4%
a	565127	12.6%
n	387470	8.6%
c	322724	7.2%
/	276793	6.2%
t	274571	6.1%
e	246504	5.5%
A	169402	3.8%
r	164694	3.7%
h	161497	3.6%
Other values (21)	1274774	28.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3467271	77.2%
Uppercase Letter	633177	14.1%
Other Punctuation	276793	6.2%
Space Separator	112455	2.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	646140	18.6%
a	565127	16.3%
n	387470	11.2%
c	322724	9.3%
t	274571	7.9%
e	246504	7.1%
r	164694	4.7%
h	161497	4.7%
s	141673	4.1%
o	121692	3.5%
Other values (8)	435179	12.6%

Uppercase Letter

Value	Count	Frequency (%)
A	169402	26.8%
W	152082	24.0%
H	102862	16.2%
L	102862	16.2%
B	71069	11.2%
M	9415	1.5%
E	9415	1.5%
S	9415	1.5%
P	2929	0.5%
I	2929	0.5%

Other Punctuation

Value	Count	Frequency (%)
/	276793	100.0%

Space Separator

Value	Count	Frequency (%)
	112455	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4100448	91.3%
Common	389248	8.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	646140	15.8%
a	565127	13.8%
n	387470	9.4%
c	322724	7.9%
t	274571	6.7%
e	246504	6.0%
A	169402	4.1%
r	164694	4.0%
h	161497	3.9%
W	152082	3.7%
Other values (19)	1010237	24.6%

Common

Value	Count	Frequency (%)
/	276793	71.1%
	112455	28.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4489696	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	646140	14.4%
a	565127	12.6%
n	387470	8.6%
c	322724	7.2%
/	276793	6.2%
t	274571	6.1%
e	246504	5.5%
A	169402	3.8%
r	164694	3.7%
h	161497	3.6%
Other values (21)	1274774	28.4%

disability
Categorical

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

None	339692
Mental health condition	11949
Other disability	2022
Intellectual or developmental disability, including dementia	944
Speech impairment or limited use of language	710
Other values (3)	889

Length

Max length	60
Median length	4
Mean length	4.992495915
Min length	4

Characters and Unicode

Total characters	1778357
Distinct characters	29
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	None
2nd row	None
3rd row	None
4th row	None
5th row	None

Common Values

Value	Count	Frequency (%)
None	339692	95.4%
Mental health condition	11949	3.4%
Other disability	2022	0.6%
Intellectual or developmental disability, including dementia	944	0.3%
Speech impairment or limited use of language	710	0.2%
Deafness or difficulty hearing	559	0.2%
Blind or limited vision	325	0.1%
Disability related to hyperactivity or impulsive behavior	5	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
none	339692	86.3%
condition	11949	3.0%
health	11949	3.0%
mental	11949	3.0%
disability	2971	0.8%
or	2543	0.6%
other	2022	0.5%
limited	1035	0.3%
intellectual	944	0.2%
dementia	944	0.2%
Other values (17)	7790	2.0%

Most occurring characters

Value	Count	Frequency (%)
n	383447	21.6%
e	378507	21.3%
o	368122	20.7%
N	339692	19.1%
t	46940	2.6%
i	41810	2.4%
	37582	2.1%
l	35172	2.0%
a	32964	1.9%
h	27199	1.5%
Other values (19)	86922	4.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1383625	77.8%
Uppercase Letter	356206	20.0%
Space Separator	37582	2.1%
Other Punctuation	944	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	383447	27.7%
e	378507	27.4%
o	368122	26.6%
t	46940	3.4%
i	41810	3.0%
l	35172	2.5%
a	32964	2.4%
h	27199	2.0%
d	19671	1.4%
c	15111	1.1%
Other values (10)	34682	2.5%

Uppercase Letter

Value	Count	Frequency (%)
N	339692	95.4%
M	11949	3.4%
O	2022	0.6%
I	944	0.3%
S	710	0.2%
D	564	0.2%
B	325	0.1%

Space Separator

Value	Count	Frequency (%)
	37582	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	944	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1739831	97.8%
Common	38526	2.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	383447	22.0%
e	378507	21.8%
o	368122	21.2%
N	339692	19.5%
t	46940	2.7%
i	41810	2.4%
l	35172	2.0%
a	32964	1.9%
h	27199	1.6%
d	19671	1.1%
Other values (17)	66307	3.8%

Common

Value	Count	Frequency (%)
	37582	97.5%
,	944	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1778357	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	383447	21.6%
e	378507	21.3%
o	368122	20.7%
N	339692	19.1%
t	46940	2.6%
i	41810	2.4%
	37582	2.1%
l	35172	2.0%
a	32964	1.9%
h	27199	1.5%
Other values (19)	86922	4.9%

reason_for_stop_code
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

reason_for_stop_code_text
Categorical

HIGH CARDINALITY
MISSING

Distinct	1566
Distinct (%)	0.5%
Missing	20564
Missing (%)	5.8%
Memory size	2.7 MiB

65002 ZZ - LOCAL ORDINANCE VIOL (I) 65002	23635
647(E) PC - DIS CON:LODGE W/O CONSENT (M) 32111	16917
602 PC - TRESPASSING (M) 32022	16078
65000 ZZ - LOCAL ORDINANCE VIOL (M) 65000	13955
22350 VC - UNSAFE SPEED:PREVAIL COND (I) 54106	13546
Other values (1561)	251511

Length

Max length	67
Median length	46
Mean length	44.12087581
Min length	3

Characters and Unicode

Total characters	14808819
Distinct characters	67
Distinct categories	10 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	409 ?
Unique (%)	0.1%

Sample

1st row	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005
2nd row	22350 VC - UNSAFE SPEED:PREVAIL COND (I) 54106
3rd row	415(1) PC - FIGHT IN PUBLIC PLACE (M) 53072
4th row	415(1) PC - FIGHT IN PUBLIC PLACE (M) 53072
5th row	22350 VC - UNSAFE SPEED:PREVAIL COND (I) 54106

Common Values

Value	Count	Frequency (%)
65002 ZZ - LOCAL ORDINANCE VIOL (I) 65002	23635	6.6%
647(E) PC - DIS CON:LODGE W/O CONSENT (M) 32111	16917	4.7%
602 PC - TRESPASSING (M) 32022	16078	4.5%
65000 ZZ - LOCAL ORDINANCE VIOL (M) 65000	13955	3.9%
22350 VC - UNSAFE SPEED:PREVAIL COND (I) 54106	13546	3.8%
22450(A) VC - FAIL STOP VEH:XWALK/ETC (I) 54167	12563	3.5%
NA - XX ZZ - COMMUNITY CARETAKING (X) 99990	11891	3.3%
23123.5 VC - NO HND HLD DEVICE W/DRIVE (I) 54655	9038	2.5%
647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005	8907	2.5%
21461(A) VC - DRIVER FAIL OBEY SIGN/ETC (I) 54146	8463	2.4%
Other values (1556)	200649	56.3%
(Missing)	20564	5.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	352617	12.7%
i	186180	6.7%
vc	155523	5.6%
m	114251	4.1%
pc	104115	3.8%
zz	53711	1.9%
65002	47270	1.7%
viol	45233	1.6%
fail	44851	1.6%
ordinance	37590	1.4%
Other values (5434)	1625176	58.7%

Most occurring characters

Value	Count	Frequency (%)
	2430875	16.4%
I	699463	4.7%
E	668412	4.5%
C	646125	4.4%
A	571519	3.9%
(	547835	3.7%
)	547791	3.7%
O	543233	3.7%
0	524036	3.5%
2	486597	3.3%
Other values (57)	7142933	48.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7514356	50.7%
Decimal Number	3118287	21.1%
Space Separator	2430875	16.4%
Open Punctuation	547835	3.7%
Close Punctuation	547791	3.7%
Dash Punctuation	353078	2.4%
Other Punctuation	295705	2.0%
Currency Symbol	676	< 0.1%
Math Symbol	171	< 0.1%
Lowercase Letter	45	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	699463	9.3%
E	668412	8.9%
C	646125	8.6%
A	571519	7.6%
O	543233	7.2%
L	470461	6.3%
N	470388	6.3%
T	383542	5.1%
S	380058	5.1%
P	363154	4.8%
Other values (16)	2318001	30.8%

Lowercase Letter

Value	Count	Frequency (%)
i	7	15.6%
t	5	11.1%
e	4	8.9%
l	4	8.9%
r	3	6.7%
u	3	6.7%
d	3	6.7%
s	2	4.4%
a	2	4.4%
o	2	4.4%
Other values (8)	10	22.2%

Decimal Number

Value	Count	Frequency (%)
0	524036	16.8%
2	486597	15.6%
5	483380	15.5%
4	400380	12.8%
1	392265	12.6%
6	297787	9.5%
3	238523	7.6%
9	130885	4.2%
7	105416	3.4%
8	59018	1.9%

Other Punctuation

Value	Count	Frequency (%)
/	149979	50.7%
:	119152	40.3%
.	23237	7.9%
&	3202	1.1%
'	85	< 0.1%
"	48	< 0.1%
,	2	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	547835	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	547791	100.0%

Space Separator

Value	Count	Frequency (%)
	2430875	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	353078	100.0%

Math Symbol

Value	Count	Frequency (%)
+	171	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	676	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7514401	50.7%
Common	7294418	49.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	699463	9.3%
E	668412	8.9%
C	646125	8.6%
A	571519	7.6%
O	543233	7.2%
L	470461	6.3%
N	470388	6.3%
T	383542	5.1%
S	380058	5.1%
P	363154	4.8%
Other values (34)	2318046	30.8%

Common

Value	Count	Frequency (%)
	2430875	33.3%
(	547835	7.5%
)	547791	7.5%
0	524036	7.2%
2	486597	6.7%
5	483380	6.6%
4	400380	5.5%
1	392265	5.4%
-	353078	4.8%
6	297787	4.1%
Other values (13)	830394	11.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14808819	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	2430875	16.4%
I	699463	4.7%
E	668412	4.5%
C	646125	4.4%
A	571519	3.9%
(	547835	3.7%
)	547791	3.7%
O	543233	3.7%
0	524036	3.5%
2	486597	3.3%
Other values (57)	7142933	48.2%

reason_for_stop
Categorical

HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

Reasonable Suspicion	186786
Traffic Violation	148855
Consensual Encounter resulting in a search	5920
Investigation to determine whether the person was truant	5751
Known to be on Parole / Probation / PRCS / Mandatory Supervision	5095
Other values (5)	3799

Length

Max length	100
Median length	20
Mean length	20.67503916
Min length	7

Characters and Unicode

Total characters	7364573
Distinct characters	44
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Reasonable Suspicion
2nd row	Traffic Violation
3rd row	Reasonable Suspicion
4th row	Reasonable Suspicion
5th row	Traffic Violation

Common Values

Value	Count	Frequency (%)
Reasonable Suspicion	186786	52.4%
Traffic Violation	148855	41.8%
Consensual Encounter resulting in a search	5920	1.7%
Investigation to determine whether the person was truant	5751	1.6%
Known to be on Parole / Probation / PRCS / Mandatory Supervision	5095	1.4%
Knowledge of outstanding arrest warrant/wanted person	3764	1.1%
Determine whether the student violated school policy	27	< 0.1%
Possible conduct warranting discipline under Education Code sections 48900, 48900.2, 48900.3, 48900.	6	< 0.1%
N,None"	1	< 0.1%
N,Person removed from vehicle by order"	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
suspicion	186786	22.3%
reasonable	186786	22.3%
traffic	148855	17.8%
violation	148855	17.8%
	15285	1.8%
to	10846	1.3%
person	9515	1.1%
resulting	5920	0.7%
search	5920	0.7%
a	5920	0.7%
Other values (44)	112114	13.4%

Most occurring characters

Value	Count	Frequency (%)
i	868403	11.8%
o	756334	10.3%
a	745540	10.1%
n	639954	8.7%
	480596	6.5%
e	477618	6.5%
s	430977	5.9%
l	356434	4.8%
c	347566	4.7%
f	301475	4.1%
Other values (34)	1959676	26.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6126215	83.2%
Uppercase Letter	738541	10.0%
Space Separator	480596	6.5%
Other Punctuation	19089	0.3%
Decimal Number	132	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	868403	14.2%
o	756334	12.3%
a	745540	12.2%
n	639954	10.4%
e	477618	7.8%
s	430977	7.0%
l	356434	5.8%
c	347566	5.7%
f	301475	4.9%
t	240994	3.9%
Other values (11)	960920	15.7%

Uppercase Letter

Value	Count	Frequency (%)
S	196976	26.7%
R	191881	26.0%
T	148855	20.2%
V	148855	20.2%
P	15292	2.1%
C	11021	1.5%
K	8859	1.2%
E	5926	0.8%
I	5751	0.8%
M	5095	0.7%
Other values (2)	30	< 0.1%

Decimal Number

Value	Count	Frequency (%)
0	48	36.4%
4	24	18.2%
8	24	18.2%
9	24	18.2%
2	6	4.5%
3	6	4.5%

Other Punctuation

Value	Count	Frequency (%)
/	19049	99.8%
,	20	0.1%
.	18	0.1%
"	2	< 0.1%

Space Separator

Value	Count	Frequency (%)
	480596	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6864756	93.2%
Common	499817	6.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	868403	12.7%
o	756334	11.0%
a	745540	10.9%
n	639954	9.3%
e	477618	7.0%
s	430977	6.3%
l	356434	5.2%
c	347566	5.1%
f	301475	4.4%
t	240994	3.5%
Other values (23)	1699461	24.8%

Common

Value	Count	Frequency (%)
	480596	96.2%
/	19049	3.8%
0	48	< 0.1%
4	24	< 0.1%
8	24	< 0.1%
9	24	< 0.1%
,	20	< 0.1%
.	18	< 0.1%
2	6	< 0.1%
3	6	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7364573	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	868403	11.8%
o	756334	10.3%
a	745540	10.1%
n	639954	8.7%
	480596	6.5%
e	477618	6.5%
s	430977	5.9%
l	356434	4.8%
c	347566	4.7%
f	301475	4.1%
Other values (34)	1959676	26.6%

reason_for_stop_detail
Categorical

HIGH CORRELATION
MISSING

Distinct	15
Distinct (%)	< 0.1%
Missing	20559
Missing (%)	5.8%
Memory size	2.7 MiB

Moving Violation	93602
Officer witnessed commission of a crime	74999
Matched suspect description	60965
Equipment Violation	41879
Other Reasonable Suspicion of a crime	37660
Other values (10)	26542

Length

Max length	73
Median length	27
Mean length	28.78694283
Min length	16

Characters and Unicode

Total characters	9662251
Distinct characters	47
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Officer witnessed commission of a crime
2nd row	Moving Violation
3rd row	Matched suspect description
4th row	Other Reasonable Suspicion of a crime
5th row	Moving Violation

Common Values

Value	Count	Frequency (%)
Moving Violation	93602	26.3%
Officer witnessed commission of a crime	74999	21.1%
Matched suspect description	60965	17.1%
Equipment Violation	41879	11.8%
Other Reasonable Suspicion of a crime	37660	10.6%
Non-moving Violation, including Registration Violation	13374	3.8%
Witness or Victim identification of Suspect at the scene	9597	2.7%
Actions indicative of casing a victim or location	1149	0.3%
Actions indicative of drug transaction	1128	0.3%
Actions indicative of engaging in violent crime	513	0.1%
Other values (5)	781	0.2%
(Missing)	20559	5.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
violation	162229	12.4%
of	125311	9.6%
a	113808	8.7%
crime	113172	8.7%
moving	93602	7.2%
officer	74999	5.7%
commission	74999	5.7%
witnessed	74999	5.7%
suspect	70562	5.4%
description	60965	4.7%
Other values (44)	339737	26.0%

Most occurring characters

Value	Count	Frequency (%)
i	1224651	12.7%
	968736	10.0%
o	898184	9.3%
e	751760	7.8%
n	702237	7.3%
s	616623	6.4%
t	605565	6.3%
c	547197	5.7%
a	453533	4.7%
m	329173	3.4%
Other values (37)	2564592	26.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8059403	83.4%
Space Separator	968736	10.0%
Uppercase Letter	607314	6.3%
Other Punctuation	13381	0.1%
Dash Punctuation	13380	0.1%
Decimal Number	35	< 0.1%
Open Punctuation	1	< 0.1%
Close Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	1224651	15.2%
o	898184	11.1%
e	751760	9.3%
n	702237	8.7%
s	616623	7.7%
t	605565	7.5%
c	547197	6.8%
a	453533	5.6%
m	329173	4.1%
r	314221	3.9%
Other values (15)	1616259	20.1%

Uppercase Letter

Value	Count	Frequency (%)
V	171826	28.3%
M	154567	25.5%
O	113169	18.6%
R	51034	8.4%
S	48038	7.9%
E	41879	6.9%
N	13374	2.2%
W	9597	1.6%
A	3055	0.5%
C	510	0.1%

Decimal Number

Value	Count	Frequency (%)
0	12	34.3%
4	8	22.9%
8	6	17.1%
9	6	17.1%
7	3	8.6%

Other Punctuation

Value	Count	Frequency (%)
,	13376	> 99.9%
.	5	< 0.1%

Space Separator

Value	Count	Frequency (%)
	968736	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	13380	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8666717	89.7%
Common	995534	10.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	1224651	14.1%
o	898184	10.4%
e	751760	8.7%
n	702237	8.1%
s	616623	7.1%
t	605565	7.0%
c	547197	6.3%
a	453533	5.2%
m	329173	3.8%
r	314221	3.6%
Other values (26)	2223573	25.7%

Common

Value	Count	Frequency (%)
	968736	97.3%
-	13380	1.3%
,	13376	1.3%
0	12	< 0.1%
4	8	< 0.1%
8	6	< 0.1%
9	6	< 0.1%
.	5	< 0.1%
7	3	< 0.1%
(	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9662251	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	1224651	12.7%
	968736	10.0%
o	898184	9.3%
e	751760	7.8%
n	702237	7.3%
s	616623	6.4%
t	605565	6.3%
c	547197	5.7%
a	453533	4.7%
m	329173	3.4%
Other values (37)	2564592	26.5%

reason_for_stop_explanation
Categorical

HIGH CARDINALITY

Distinct	170749
Distinct (%)	47.9%
Missing	2
Missing (%)	< 0.1%
Memory size	2.7 MiB

Speeding	4225
cell phone	3756
radio call	3347
encroachment	3007
stop sign	2694
Other values (170744)	339175

Length

Max length	100
Median length	21
Mean length	28.53074362
Min length	3

Characters and Unicode

Total characters	10162765
Distinct characters	92
Distinct categories	13 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	146502 ?
Unique (%)	41.1%

Sample

1st row	staggering, unable to safely walk
2nd row	Speeding
3rd row	Both parties involved in argument.
4th row	Both parties engaged in argument.
5th row	UNSAFE DRIVING

Common Values

Value	Count	Frequency (%)
Speeding	4225	1.2%
cell phone	3756	1.1%
radio call	3347	0.9%
encroachment	3007	0.8%
stop sign	2694	0.8%
SPEED	2192	0.6%
speeding	2104	0.6%
STOP SIGN	2062	0.6%
CELL PHONE	1810	0.5%
ped stop	1768	0.5%
Other values (170739)	329239	92.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
in	48869	2.8%
of	44153	2.6%
subject	43865	2.6%
on	40241	2.3%
a	35235	2.1%
was	31443	1.8%
to	30175	1.8%
stop	28949	1.7%
call	27392	1.6%
radio	24561	1.4%
Other values (26554)	1363487	79.3%

Most occurring characters

Value	Count	Frequency (%)
	1389317	13.7%
e	644662	6.3%
i	494760	4.9%
t	463450	4.6%
n	461364	4.5%
a	460065	4.5%
o	432574	4.3%
s	365550	3.6%
r	350200	3.4%
l	317730	3.1%
Other values (82)	4783093	47.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5902529	58.1%
Uppercase Letter	2622930	25.8%
Space Separator	1389317	13.7%
Decimal Number	154342	1.5%
Other Punctuation	81885	0.8%
Dash Punctuation	5739	0.1%
Open Punctuation	2923	< 0.1%
Close Punctuation	2848	< 0.1%
Math Symbol	180	< 0.1%
Currency Symbol	58	< 0.1%
Other values (3)	14	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	644662	10.9%
i	494760	8.4%
t	463450	7.9%
n	461364	7.8%
a	460065	7.8%
o	432574	7.3%
s	365550	6.2%
r	350200	5.9%
l	317730	5.4%
d	257388	4.4%
Other values (16)	1654786	28.0%

Uppercase Letter

Value	Count	Frequency (%)
E	273695	10.4%
I	215910	8.2%
T	196201	7.5%
N	196005	7.5%
S	191447	7.3%
O	188860	7.2%
A	187968	7.2%
R	158051	6.0%
L	142726	5.4%
D	122400	4.7%
Other values (16)	749667	28.6%

Other Punctuation

Value	Count	Frequency (%)
.	50886	62.1%
,	15856	19.4%
/	10890	13.3%
'	2007	2.5%
&	635	0.8%
"	553	0.7%
;	249	0.3%
:	229	0.3%
*	209	0.3%
#	186	0.2%
Other values (4)	185	0.2%

Decimal Number

Value	Count	Frequency (%)
5	35598	23.1%
1	34125	22.1%
0	26252	17.0%
4	17437	11.3%
2	13134	8.5%
6	8780	5.7%
3	5051	3.3%
7	5039	3.3%
8	4729	3.1%
9	4197	2.7%

Math Symbol

Value	Count	Frequency (%)
+	147	81.7%
>	17	9.4%
<	8	4.4%
=	7	3.9%
~	1	0.6%

Open Punctuation

Value	Count	Frequency (%)
(	2897	99.1%
[	26	0.9%

Close Punctuation

Value	Count	Frequency (%)
)	2845	99.9%
]	3	0.1%

Modifier Symbol

Value	Count	Frequency (%)
^	5	62.5%
`	3	37.5%

Space Separator

Value	Count	Frequency (%)
	1389317	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5739	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	58	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	5	100.0%

Control

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8525459	83.9%
Common	1637306	16.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	644662	7.6%
i	494760	5.8%
t	463450	5.4%
n	461364	5.4%
a	460065	5.4%
o	432574	5.1%
s	365550	4.3%
r	350200	4.1%
l	317730	3.7%
E	273695	3.2%
Other values (42)	4261409	50.0%

Common

Value	Count	Frequency (%)
	1389317	84.9%
.	50886	3.1%
5	35598	2.2%
1	34125	2.1%
0	26252	1.6%
4	17437	1.1%
,	15856	1.0%
2	13134	0.8%
/	10890	0.7%
6	8780	0.5%
Other values (30)	35031	2.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10162765	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1389317	13.7%
e	644662	6.3%
i	494760	4.9%
t	463450	4.6%
n	461364	4.5%
a	460065	4.5%
o	432574	4.3%
s	365550	3.6%
r	350200	3.4%
l	317730	3.1%
Other values (82)	4783093	47.1%

action
Categorical

HIGH CORRELATION

Distinct	25
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	2.7 MiB

None	222514
Handcuffed or flex cuffed	38323
Curbside detention	34942
Search of person was conducted	17858
Patrol car detention	14709
Other values (20)	27859

Length

Max length	52
Median length	4
Mean length	11.63413765
Min length	4

Characters and Unicode

Total characters	4144138
Distinct characters	37
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	None
2nd row	None
3rd row	Curbside detention
4th row	Curbside detention
5th row	None

Common Values

Value	Count	Frequency (%)
None	222514	62.5%
Handcuffed or flex cuffed	38323	10.8%
Curbside detention	34942	9.8%
Search of person was conducted	17858	5.0%
Patrol car detention	14709	4.1%
Search of property was conducted	6978	2.0%
Person removed from vehicle by order	5217	1.5%
Asked for consent to search person	3309	0.9%
Person photographed	2828	0.8%
Asked for consent to search property	2376	0.7%
Other values (15)	7151	2.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
none	222514	31.3%
detention	49651	7.0%
or	40035	5.6%
flex	38323	5.4%
handcuffed	38323	5.4%
cuffed	38323	5.4%
curbside	34942	4.9%
search	30593	4.3%
person	29672	4.2%
conducted	26686	3.8%
Other values (47)	161015	22.7%

Most occurring characters

Value	Count	Frequency (%)
e	628279	15.2%
o	463527	11.2%
n	431783	10.4%
	353872	8.5%
d	279068	6.7%
f	227609	5.5%
N	222514	5.4%
r	219094	5.3%
c	195054	4.7%
t	175927	4.2%
Other values (27)	947411	22.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3432482	82.8%
Uppercase Letter	357784	8.6%
Space Separator	353872	8.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	628279	18.3%
o	463527	13.5%
n	431783	12.6%
d	279068	8.1%
f	227609	6.6%
r	219094	6.4%
c	195054	5.7%
t	175927	5.1%
u	139974	4.1%
a	132018	3.8%
Other values (15)	540149	15.7%

Uppercase Letter

Value	Count	Frequency (%)
N	222514	62.2%
H	38323	10.7%
C	35135	9.8%
P	26048	7.3%
S	24836	6.9%
A	5715	1.6%
V	2981	0.8%
F	2144	0.6%
E	72	< 0.1%
B	11	< 0.1%

Space Separator

Value	Count	Frequency (%)
	353872	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3790266	91.5%
Common	353872	8.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	628279	16.6%
o	463527	12.2%
n	431783	11.4%
d	279068	7.4%
f	227609	6.0%
N	222514	5.9%
r	219094	5.8%
c	195054	5.1%
t	175927	4.6%
u	139974	3.7%
Other values (26)	807437	21.3%

Common

Value	Count	Frequency (%)
	353872	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4144138	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	628279	15.2%
o	463527	11.2%
n	431783	10.4%
	353872	8.5%
d	279068	6.7%
f	227609	5.5%
N	222514	5.4%
r	219094	5.3%
c	195054	4.7%
t	175927	4.2%
Other values (27)	947411	22.9%

consented
Boolean

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	350521
Missing (%)	98.4%
Memory size	695.8 KiB

True	4914
False	771
(Missing)	350521

Common Values
Chart

Value	Count	Frequency (%)
True	4914	1.4%
False	771	0.2%
(Missing)	350521	98.4%

basis_for_search
Categorical

HIGH CORRELATION
MISSING

Distinct	13
Distinct (%)	< 0.1%
Missing	282703
Missing (%)	79.4%
Memory size	2.7 MiB

Incident to arrest	36676
Condition of parole / probation/ PRCS / mandatory supervision	21787
Consent given	5532
Officer Safety/safety of others	4392
Vehicle inventory	1881
Other values (8)	3235

Length

Max length	61
Median length	18
Mean length	31.11370964
Min length	13

Characters and Unicode

Total characters	2286951
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Incident to arrest
2nd row	Incident to arrest
3rd row	Incident to arrest
4th row	Condition of parole / probation/ PRCS / mandatory supervision
5th row	Incident to arrest

Common Values

Value	Count	Frequency (%)
Incident to arrest	36676	10.3%
Condition of parole / probation/ PRCS / mandatory supervision	21787	6.1%
Consent given	5532	1.6%
Officer Safety/safety of others	4392	1.2%
Vehicle inventory	1881	0.5%
Visible contraband	848	0.2%
Evidence of crime	775	0.2%
Suspected weapons	674	0.2%
Odor of contraband	453	0.1%
Search Warrant	310	0.1%
Other values (3)	175	< 0.1%
(Missing)	282703	79.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	43574	12.6%
to	36676	10.6%
incident	36676	10.6%
arrest	36676	10.6%
of	27414	7.9%
prcs	21787	6.3%
supervision	21787	6.3%
condition	21787	6.3%
mandatory	21787	6.3%
parole	21787	6.3%
Other values (24)	56273	16.3%

Most occurring characters

Value	Count	Frequency (%)
	272721	11.9%
o	230875	10.1%
n	207517	9.1%
t	198613	8.7%
r	174944	7.6%
i	162900	7.1%
e	157544	6.9%
a	136989	6.0%
s	97096	4.2%
d	83468	3.6%
Other values (23)	564284	24.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1778964	77.8%
Space Separator	272721	11.9%
Uppercase Letter	165353	7.2%
Other Punctuation	69913	3.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	230875	13.0%
n	207517	11.7%
t	198613	11.2%
r	174944	9.8%
i	162900	9.2%
e	157544	8.9%
a	136989	7.7%
s	97096	5.5%
d	83468	4.7%
p	66723	3.8%
Other values (12)	262295	14.7%

Uppercase Letter

Value	Count	Frequency (%)
C	49114	29.7%
I	36676	22.2%
S	27170	16.4%
P	21787	13.2%
R	21787	13.2%
O	4845	2.9%
V	2729	1.7%
E	935	0.6%
W	310	0.2%

Space Separator

Value	Count	Frequency (%)
	272721	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	69913	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1944317	85.0%
Common	342634	15.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	230875	11.9%
n	207517	10.7%
t	198613	10.2%
r	174944	9.0%
i	162900	8.4%
e	157544	8.1%
a	136989	7.0%
s	97096	5.0%
d	83468	4.3%
p	66723	3.4%
Other values (21)	427648	22.0%

Common

Value	Count	Frequency (%)
	272721	79.6%
/	69913	20.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2286951	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	272721	11.9%
o	230875	10.1%
n	207517	9.1%
t	198613	8.7%
r	174944	7.6%
i	162900	7.1%
e	157544	6.9%
a	136989	6.0%
s	97096	4.2%
d	83468	3.6%
Other values (23)	564284	24.7%

basis_for_search_explanation
Categorical

HIGH CARDINALITY
MISSING

Distinct	26425
Distinct (%)	49.3%
Missing	302561
Missing (%)	84.9%
Memory size	2.7 MiB

incident to arrest	1599
arrest	1426
search incident to arrest	1097
arrested	598
Incident to arrest	511
Other values (26420)	48414

Length

Max length	100
Median length	22
Mean length	27.82494175
Min length	1

Characters and Unicode

Total characters	1492669
Distinct characters	88
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	22965 ?
Unique (%)	42.8%

Sample

1st row	subject was transported to detox and was searched accordingly.
2nd row	INCIDENT TO ARREST
3rd row	DRUNK IN PUBLIC
4th row	4th waiver
5th row	FIGHTING

Common Values

Value	Count	Frequency (%)
incident to arrest	1599	0.4%
arrest	1426	0.4%
search incident to arrest	1097	0.3%
arrested	598	0.2%
Incident to arrest	511	0.1%
INCIDENT TO ARREST	483	0.1%
searched incident to arrest	481	0.1%
5150 hold	391	0.1%
warrant	384	0.1%
SEARCH INCIDENT TO ARREST	375	0.1%
Other values (26415)	46300	13.0%
(Missing)	302561	84.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
arrest	17262	7.1%
to	15922	6.5%
for	12136	5.0%
incident	9689	4.0%
arrested	8073	3.3%
subject	7567	3.1%
search	7547	3.1%
was	7070	2.9%
searched	5396	2.2%
and	5193	2.1%
Other values (6895)	148694	60.8%

Most occurring characters

Value	Count	Frequency (%)
	195205	13.1%
e	116049	7.8%
r	100287	6.7%
t	87551	5.9%
a	85512	5.7%
n	70046	4.7%
s	66555	4.5%
o	62638	4.2%
i	53202	3.6%
d	50141	3.4%
Other values (78)	605483	40.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	924166	61.9%
Uppercase Letter	309379	20.7%
Space Separator	195205	13.1%
Decimal Number	46230	3.1%
Other Punctuation	12075	0.8%
Open Punctuation	2503	0.2%
Close Punctuation	2503	0.2%
Dash Punctuation	557	< 0.1%
Math Symbol	38	< 0.1%
Currency Symbol	10	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	116049	12.6%
r	100287	10.9%
t	87551	9.5%
a	85512	9.3%
n	70046	7.6%
s	66555	7.2%
o	62638	6.8%
i	53202	5.8%
d	50141	5.4%
c	49111	5.3%
Other values (16)	183074	19.8%

Uppercase Letter

Value	Count	Frequency (%)
E	33782	10.9%
R	29269	9.5%
A	28661	9.3%
T	26582	8.6%
S	26387	8.5%
N	22069	7.1%
O	20050	6.5%
I	19547	6.3%
C	17521	5.7%
D	16630	5.4%
Other values (16)	68881	22.3%

Other Punctuation

Value	Count	Frequency (%)
.	8116	67.2%
,	2215	18.3%
/	888	7.4%
&	423	3.5%
'	251	2.1%
:	57	0.5%
;	48	0.4%
"	35	0.3%
*	13	0.1%
#	12	0.1%
Other values (3)	17	0.1%

Decimal Number

Value	Count	Frequency (%)
5	11278	24.4%
1	10048	21.7%
0	6660	14.4%
4	4943	10.7%
2	3745	8.1%
6	2886	6.2%
7	2476	5.4%
3	1816	3.9%
9	1418	3.1%
8	960	2.1%

Math Symbol

Value	Count	Frequency (%)
>	29	76.3%
=	5	13.2%
+	3	7.9%
<	1	2.6%

Open Punctuation

Value	Count	Frequency (%)
(	2502	> 99.9%
[	1	< 0.1%

Close Punctuation

Value	Count	Frequency (%)
)	2501	99.9%
]	2	0.1%

Modifier Symbol

Value	Count	Frequency (%)
^	2	66.7%
`	1	33.3%

Space Separator

Value	Count	Frequency (%)
	195205	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	557	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	10	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1233545	82.6%
Common	259124	17.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	116049	9.4%
r	100287	8.1%
t	87551	7.1%
a	85512	6.9%
n	70046	5.7%
s	66555	5.4%
o	62638	5.1%
i	53202	4.3%
d	50141	4.1%
c	49111	4.0%
Other values (42)	492453	39.9%

Common

Value	Count	Frequency (%)
	195205	75.3%
5	11278	4.4%
1	10048	3.9%
.	8116	3.1%
0	6660	2.6%
4	4943	1.9%
2	3745	1.4%
6	2886	1.1%
(	2502	1.0%
)	2501	1.0%
Other values (26)	11240	4.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1492669	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	195205	13.1%
e	116049	7.8%
r	100287	6.7%
t	87551	5.9%
a	85512	5.7%
n	70046	4.7%
s	66555	4.5%
o	62638	4.2%
i	53202	3.6%
d	50141	3.4%
Other values (78)	605483	40.6%

basis_for_property_seizure
Categorical

HIGH CORRELATION
MISSING

Distinct	7
Distinct (%)	0.1%
Missing	348426
Missing (%)	97.8%
Memory size	2.7 MiB

Evidence	3272
Contraband	2865
Impound of vehicle	1054
Safekeeping as allowed by law/statute	510
Abandoned property	75
Other values (2)	4

Length

Max length	37
Median length	10
Mean length	12.09974293
Min length	8

Characters and Unicode

Total characters	94136
Distinct characters	29
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Impound of vehicle
2nd row	Evidence
3rd row	Impound of vehicle
4th row	Evidence
5th row	Contraband

Common Values

Value	Count	Frequency (%)
Evidence	3272	0.9%
Contraband	2865	0.8%
Impound of vehicle	1054	0.3%
Safekeeping as allowed by law/statute	510	0.1%
Abandoned property	75	< 0.1%
Suspected violation of school policy	2	< 0.1%
Citation for infraction	2	< 0.1%
(Missing)	348426	97.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
evidence	3272	27.2%
contraband	2865	23.8%
of	1056	8.8%
impound	1054	8.8%
vehicle	1054	8.8%
law/statute	510	4.2%
allowed	510	4.2%
as	510	4.2%
safekeeping	510	4.2%
by	510	4.2%
Other values (9)	164	1.4%

Most occurring characters

Value	Count	Frequency (%)
e	11356	12.1%
n	10724	11.4%
a	8361	8.9%
d	7853	8.3%
o	5651	6.0%
i	4850	5.2%
t	4480	4.8%
c	4334	4.6%
v	4328	4.6%
	4235	4.5%
Other values (19)	27964	29.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	81611	86.7%
Uppercase Letter	7780	8.3%
Space Separator	4235	4.5%
Other Punctuation	510	0.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	11356	13.9%
n	10724	13.1%
a	8361	10.2%
d	7853	9.6%
o	5651	6.9%
i	4850	5.9%
t	4480	5.5%
c	4334	5.3%
v	4328	5.3%
b	3450	4.2%
Other values (12)	16224	19.9%

Uppercase Letter

Value	Count	Frequency (%)
E	3272	42.1%
C	2867	36.9%
I	1054	13.5%
S	512	6.6%
A	75	1.0%

Space Separator

Value	Count	Frequency (%)
	4235	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	510	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	89391	95.0%
Common	4745	5.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	11356	12.7%
n	10724	12.0%
a	8361	9.4%
d	7853	8.8%
o	5651	6.3%
i	4850	5.4%
t	4480	5.0%
c	4334	4.8%
v	4328	4.8%
b	3450	3.9%
Other values (17)	24004	26.9%

Common

Value	Count	Frequency (%)
	4235	89.3%
/	510	10.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	94136	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	11356	12.1%
n	10724	11.4%
a	8361	8.9%
d	7853	8.3%
o	5651	6.0%
i	4850	5.2%
t	4480	4.8%
c	4334	4.6%
v	4328	4.6%
	4235	4.5%
Other values (19)	27964	29.7%

type_of_property_seized
Categorical

HIGH CORRELATION
MISSING

Distinct	13
Distinct (%)	0.2%
Missing	348426
Missing (%)	97.8%
Memory size	2.7 MiB

Drugs/narcotics	2699
Drug Paraphernalia	1316
Vehicle	1018
Other Contraband or evidence	606
Weapon(s) other than a firearm	595
Other values (8)	1546

Length

Max length	37
Median length	15
Mean length	16.80848329
Min length	5

Characters and Unicode

Total characters	130770
Distinct characters	40
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Vehicle
2nd row	Weapon(s) other than a firearm
3rd row	Vehicle
4th row	Drug Paraphernalia
5th row	Drug Paraphernalia

Common Values

Value	Count	Frequency (%)
Drugs/narcotics	2699	0.8%
Drug Paraphernalia	1316	0.4%
Vehicle	1018	0.3%
Other Contraband or evidence	606	0.2%
Weapon(s) other than a firearm	595	0.2%
Firearm(s)	412	0.1%
Alcohol	395	0.1%
Cell phone(s) or electronic device(s)	284	0.1%
Suspected Stolen property	231	0.1%
Money	149	< 0.1%
Other values (3)	75	< 0.1%
(Missing)	348426	97.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
drugs/narcotics	2699	18.1%
paraphernalia	1316	8.8%
drug	1316	8.8%
other	1201	8.1%
vehicle	1018	6.8%
or	890	6.0%
contraband	606	4.1%
evidence	606	4.1%
than	595	4.0%
a	595	4.0%
Other values (15)	4050	27.2%

Most occurring characters

Value	Count	Frequency (%)
r	14803	11.3%
a	11967	9.2%
e	10750	8.2%
c	8500	6.5%
n	8117	6.2%
o	7427	5.7%
i	7360	5.6%
s	7204	5.5%
	7112	5.4%
t	6151	4.7%
Other values (30)	41379	31.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	107868	82.5%
Uppercase Letter	9931	7.6%
Space Separator	7112	5.4%
Other Punctuation	2699	2.1%
Open Punctuation	1575	1.2%
Close Punctuation	1575	1.2%
Decimal Number	10	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	14803	13.7%
a	11967	11.1%
e	10750	10.0%
c	8500	7.9%
n	8117	7.5%
o	7427	6.9%
i	7360	6.8%
s	7204	6.7%
t	6151	5.7%
h	4809	4.5%
Other values (10)	20780	19.3%

Uppercase Letter

Value	Count	Frequency (%)
D	4015	40.4%
P	1316	13.3%
V	1018	10.3%
C	890	9.0%
O	606	6.1%
W	595	6.0%
A	468	4.7%
S	462	4.7%
F	412	4.1%
M	149	1.5%

Decimal Number

Value	Count	Frequency (%)
5	3	30.0%
4	2	20.0%
1	2	20.0%
0	1	10.0%
6	1	10.0%
7	1	10.0%

Open Punctuation

Value	Count	Frequency (%)
(	1575	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1575	100.0%

Space Separator

Value	Count	Frequency (%)
	7112	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	2699	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	117799	90.1%
Common	12971	9.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	14803	12.6%
a	11967	10.2%
e	10750	9.1%
c	8500	7.2%
n	8117	6.9%
o	7427	6.3%
i	7360	6.2%
s	7204	6.1%
t	6151	5.2%
h	4809	4.1%
Other values (20)	30711	26.1%

Common

Value	Count	Frequency (%)
	7112	54.8%
/	2699	20.8%
(	1575	12.1%
)	1575	12.1%
5	3	< 0.1%
4	2	< 0.1%
1	2	< 0.1%
0	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	130770	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	14803	11.3%
a	11967	9.2%
e	10750	8.2%
c	8500	6.5%
n	8117	6.2%
o	7427	5.7%
i	7360	5.6%
s	7204	5.5%
	7112	5.4%
t	6151	4.7%
Other values (30)	41379	31.6%

result_key
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

result
Categorical

HIGH CORRELATION

Distinct	13
Distinct (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Memory size	2.7 MiB

Citation for infraction	82209
Field interview card completed	76131
Warning (verbal or written)	60128
No Action	49436
Custodial Arrest without warrant	33364
Other values (8)	54936

Length

Max length	73
Median length	27
Mean length	25.34757611
Min length	9

Characters and Unicode

Total characters	9028908
Distinct characters	40
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Custodial Arrest without warrant
2nd row	Warning (verbal or written)
3rd row	No Action
4th row	No Action
5th row	No Action

Common Values

Value	Count	Frequency (%)
Citation for infraction	82209	23.1%
Field interview card completed	76131	21.4%
Warning (verbal or written)	60128	16.9%
No Action	49436	13.9%
Custodial Arrest without warrant	33364	9.4%
In-field cite and release	20791	5.8%
Psychiatric hold	13874	3.9%
Custodial Arrest pursuant to outstanding warrant	13001	3.6%
Noncriminal transport or caretaking transport	6314	1.8%
Contacted parent/legal guardian or other person responsible for the minor	911	0.3%
Other values (3)	45	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
for	83120	6.6%
citation	82209	6.6%
infraction	82209	6.6%
field	76131	6.1%
card	76131	6.1%
interview	76131	6.1%
completed	76131	6.1%
or	67358	5.4%
verbal	60128	4.8%
written	60128	4.8%
Other values (38)	514137	41.0%

Most occurring characters

Value	Count	Frequency (%)
i	910724	10.1%
	897609	9.9%
t	897362	9.9%
r	841970	9.3%
n	716633	7.9%
e	664969	7.4%
o	633184	7.0%
a	617613	6.8%
c	346047	3.8%
d	345089	3.8%
Other values (30)	2157708	23.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7537252	83.5%
Space Separator	897609	9.9%
Uppercase Letter	452065	5.0%
Open Punctuation	60128	0.7%
Close Punctuation	60128	0.7%
Dash Punctuation	20791	0.2%
Other Punctuation	935	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	910724	12.1%
t	897362	11.9%
r	841970	11.2%
n	716633	9.5%
e	664969	8.8%
o	633184	8.4%
a	617613	8.2%
c	346047	4.6%
d	345089	4.6%
l	323341	4.3%
Other values (12)	1240320	16.5%

Uppercase Letter

Value	Count	Frequency (%)
C	129497	28.6%
A	95801	21.2%
F	76131	16.8%
W	60128	13.3%
N	55750	12.3%
I	20791	4.6%
P	13874	3.1%
R	33	< 0.1%
S	24	< 0.1%
U	12	< 0.1%
Other values (2)	24	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	911	97.4%
.	24	2.6%

Space Separator

Value	Count	Frequency (%)
	897609	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	60128	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	60128	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	20791	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7989317	88.5%
Common	1039591	11.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	910724	11.4%
t	897362	11.2%
r	841970	10.5%
n	716633	9.0%
e	664969	8.3%
o	633184	7.9%
a	617613	7.7%
c	346047	4.3%
d	345089	4.3%
l	323341	4.0%
Other values (24)	1692385	21.2%

Common

Value	Count	Frequency (%)
	897609	86.3%
(	60128	5.8%
)	60128	5.8%
-	20791	2.0%
/	911	0.1%
.	24	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9028908	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	910724	10.1%
	897609	9.9%
t	897362	9.9%
r	841970	9.3%
n	716633	7.9%
e	664969	7.4%
o	633184	7.0%
a	617613	6.8%
c	346047	3.8%
d	345089	3.8%
Other values (30)	2157708	23.9%

code
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	1261
Distinct (%)	0.4%
Missing	2
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	28709.69618

Minimum	0
Maximum	99999
Zeros	159725
Zeros (%)	44.8%
Negative	0
Negative (%)	0.0%
Memory size	2.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	32111
Q3	54194
95-th percentile	65002
Maximum	99999
Range	99999
Interquartile range (IQR)	54194

Descriptive statistics

Standard deviation	27675.67946
Coefficient of variation (CV)	0.9639837111
Kurtosis	-1.672744757
Mean	28709.69618
Median Absolute Deviation (MAD)	32111
Skewness	0.1030210085
Sum	1.022650862 × 10¹⁰
Variance	765943233.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	159725	44.8%
65002	33543	9.4%
54167	8822	2.5%
54655	7569	2.1%
54106	7227	2.0%
54146	6830	1.9%
32111	5801	1.6%
65000	5360	1.5%
64005	4984	1.4%
32022	4667	1.3%
Other values (1251)	111676	31.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	159725	44.8%
3	3	< 0.1%
4021	2	< 0.1%
4022	2	< 0.1%
4031	2	< 0.1%
4032	1	< 0.1%
4033	2	< 0.1%
4034	1	< 0.1%
4037	3	< 0.1%
4043	21	< 0.1%

Value	Count	Frequency (%)
99999	1121	0.3%
99990	550	0.2%
89105	3	< 0.1%
89005	1	< 0.1%
66211	24	< 0.1%
66210	95	< 0.1%
66208	1360	0.4%
66207	196	0.1%
66205	433	0.1%
66204	6	< 0.1%

result_text
Categorical

HIGH CARDINALITY
MISSING

Distinct	1260
Distinct (%)	0.6%
Missing	159727
Missing (%)	44.8%
Memory size	2.7 MiB

65002 ZZ - LOCAL ORDINANCE VIOL (I) 65002	33543
22450(A) VC - FAIL STOP VEH:XWALK/ETC (I) 54167	8822
23123.5 VC - NO HND HLD DEVICE W/DRIVE (I) 54655	7569
22350 VC - UNSAFE SPEED:PREVAIL COND (I) 54106	7227
21461(A) VC - DRIVER FAIL OBEY SIGN/ETC (I) 54146	6830
Other values (1255)	132488

Length

Max length	56
Median length	46
Mean length	44.71599
Min length	24

Characters and Unicode

Total characters	8785753
Distinct characters	49
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	326 ?
Unique (%)	0.2%

Sample

1st row	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005
2nd row	22349(B) VC - EXC 55MPH SPEED:2 LANE RD (I) 54395
3rd row	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005
4th row	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005
5th row	245(A)(1) PC - ADW NOT FIREARM (F) 13219

Common Values

Value	Count	Frequency (%)
65002 ZZ - LOCAL ORDINANCE VIOL (I) 65002	33543	9.4%
22450(A) VC - FAIL STOP VEH:XWALK/ETC (I) 54167	8822	2.5%
23123.5 VC - NO HND HLD DEVICE W/DRIVE (I) 54655	7569	2.1%
22350 VC - UNSAFE SPEED:PREVAIL COND (I) 54106	7227	2.0%
21461(A) VC - DRIVER FAIL OBEY SIGN/ETC (I) 54146	6830	1.9%
647(E) PC - DIS CON:LODGE W/O CONSENT (M) 32111	5801	1.6%
65000 ZZ - LOCAL ORDINANCE VIOL (M) 65000	5360	1.5%
647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005	4984	1.4%
602 PC - TRESPASSING (M) 32022	4667	1.3%
25620 BP - POSS OPEN ALCOHOL:PUBLIC (I) 41063	4449	1.2%
Other values (1250)	107227	30.1%
(Missing)	159727	44.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	198310	12.2%
i	132740	8.1%
vc	99844	6.1%
65002	67086	4.1%
m	50629	3.1%
viol	43218	2.6%
zz	40577	2.5%
pc	40235	2.5%
local	38903	2.4%
ordinance	38903	2.4%
Other values (4435)	881388	54.0%

Most occurring characters

Value	Count	Frequency (%)
	1435354	16.3%
I	444256	5.1%
E	387229	4.4%
C	383546	4.4%
O	352675	4.0%
A	346513	3.9%
0	344332	3.9%
5	325492	3.7%
L	322867	3.7%
(	319667	3.6%
Other values (39)	4123822	46.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4431677	50.4%
Decimal Number	1906415	21.7%
Space Separator	1435354	16.3%
Open Punctuation	319667	3.6%
Close Punctuation	319622	3.6%
Dash Punctuation	198874	2.3%
Other Punctuation	173505	2.0%
Currency Symbol	506	< 0.1%
Math Symbol	133	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	444256	10.0%
E	387229	8.7%
C	383546	8.7%
O	352675	8.0%
A	346513	7.8%
L	322867	7.3%
N	266929	6.0%
V	225202	5.1%
S	217133	4.9%
D	210411	4.7%
Other values (16)	1274916	28.8%

Decimal Number

Value	Count	Frequency (%)
0	344332	18.1%
5	325492	17.1%
2	303800	15.9%
4	233800	12.3%
1	223130	11.7%
6	205744	10.8%
3	137177	7.2%
7	57832	3.0%
9	40141	2.1%
8	34967	1.8%

Other Punctuation

Value	Count	Frequency (%)
/	88580	51.1%
:	66678	38.4%
.	16533	9.5%
&	1493	0.9%
'	205	0.1%
"	14	< 0.1%
,	2	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	319667	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	319622	100.0%

Space Separator

Value	Count	Frequency (%)
	1435354	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	198874	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	506	100.0%

Math Symbol

Value	Count	Frequency (%)
+	133	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4431677	50.4%
Common	4354076	49.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	444256	10.0%
E	387229	8.7%
C	383546	8.7%
O	352675	8.0%
A	346513	7.8%
L	322867	7.3%
N	266929	6.0%
V	225202	5.1%
S	217133	4.9%
D	210411	4.7%
Other values (16)	1274916	28.8%

Common

Value	Count	Frequency (%)
	1435354	33.0%
0	344332	7.9%
5	325492	7.5%
(	319667	7.3%
)	319622	7.3%
2	303800	7.0%
4	233800	5.4%
1	223130	5.1%
6	205744	4.7%
-	198874	4.6%
Other values (13)	444261	10.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8785753	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1435354	16.3%
I	444256	5.1%
E	387229	4.4%
C	383546	4.4%
O	352675	4.0%
A	346513	3.9%
0	344332	3.9%
5	325492	3.7%
L	322867	3.7%
(	319667	3.6%
Other values (39)	4123822	46.9%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	stop_id	date_stop	time_stop	stop_duration	stop_in_response_to_cfs	address_city	beat	beat_name	highway_exit	address_street	intersection	address_block	landmark	school_name	ori	agency	officer_assignment_key	assignment	exp_years	pid	perceived_age	gender2	perceived_gender	gender	perceived_lgbt	race	disability	reason_for_stop_code	reason_for_stop_code_text	reason_for_stop	reason_for_stop_detail	reason_for_stop_explanation	action	consented	basis_for_search	basis_for_search_explanation	basis_for_property_seizure	type_of_property_seized	result_key	result	code	result_text
0	2443	2018-07-01	00:01:37	30	0	SAN DIEGO	122	Pacific Beach 122	NaN	Grand Avenue	NaN	700	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	10	1	25	1	Male	Male	No	White	None	64005	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005	Reasonable Suspicion	Officer witnessed commission of a crime	staggering, unable to safely walk	None	NaN	NaN	NaN	NaN	NaN	6	Custodial Arrest without warrant	64005.0	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005
1	2444	2018-07-01	00:03:34	10	0	SAN DIEGO	121	Mission Beach 121	NaN	NOBEL DRIVE	I-5	0	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	18	1	25	1	Male	Male	No	White	None	54106	22350 VC - UNSAFE SPEED:PREVAIL COND (I) 54106	Traffic Violation	Moving Violation	Speeding	None	NaN	NaN	NaN	NaN	NaN	2	Warning (verbal or written)	54395.0	22349(B) VC - EXC 55MPH SPEED:2 LANE RD (I) 54395
2	2447	2018-07-01	00:05:43	15	1	SAN DIEGO	822	El Cerrito 822	NaN	59th Street	NaN	4400	NaN	NaN	CA0371100	SD	10	Other	1	1	30	1	Male	Male	No	Hispanic/Latino/a	None	53072	415(1) PC - FIGHT IN PUBLIC PLACE (M) 53072	Reasonable Suspicion	Matched suspect description	Both parties involved in argument.	Curbside detention	NaN	NaN	NaN	NaN	NaN	1	No Action	0.0	NaN
3	2447	2018-07-01	00:05:43	15	1	SAN DIEGO	822	El Cerrito 822	NaN	59th Street	NaN	4400	NaN	NaN	CA0371100	SD	10	Other	1	2	30	2	Female	Female	No	Hispanic/Latino/a	None	53072	415(1) PC - FIGHT IN PUBLIC PLACE (M) 53072	Reasonable Suspicion	Other Reasonable Suspicion of a crime	Both parties engaged in argument.	Curbside detention	NaN	NaN	NaN	NaN	NaN	1	No Action	0.0	NaN
4	2448	2018-07-01	00:19:06	5	0	SAN DIEGO	614	Ocean Beach 614	NaN	NIAGARA AVE	NaN	4800	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	3	1	23	1	Male	Male	No	White	None	54106	22350 VC - UNSAFE SPEED:PREVAIL COND (I) 54106	Traffic Violation	Moving Violation	UNSAFE DRIVING	None	NaN	NaN	NaN	NaN	NaN	1	No Action	0.0	NaN
5	2449	2018-07-01	00:03:00	15	1	SAN DIEGO	115	University City 115	NaN	la jolla village dr	NaN	4500	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	1	1	25	1	Male	Male	No	White	None	13045	242 PC - BATTERY (M) 13045	Reasonable Suspicion	Matched suspect description	matched description of suspect on 242 radio call.	Curbside detention	NaN	Incident to arrest	subject was transported to detox and was searched accordingly.	NaN	NaN	6	Custodial Arrest without warrant	64005.0	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005
6	2451	2018-07-01	00:24:02	20	0	SAN DIEGO	122	Pacific Beach 122	NaN	Thomas	NaN	800	NaN	NaN	CA0371100	SD	10	Other	24	1	22	1	Male	Male	No	White	None	64005	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005	Reasonable Suspicion	Other Reasonable Suspicion of a crime	drunk	Handcuffed or flex cuffed	NaN	NaN	NaN	NaN	NaN	6	Custodial Arrest without warrant	64005.0	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005
7	2453	2018-07-01	00:31:19	120	0	SAN DIEGO	446	Lincoln Park 446	NaN	LOGAN AVENUE	NaN	4800	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	1	1	37	1	Male	Male	No	Black/African American	None	13219	245(A)(1) PC - ADW NOT FIREARM (F) 13219	Reasonable Suspicion	Matched suspect description	ARREST CONNECTED WITH 245A1, 594B1	Property was seized	NaN	Incident to arrest	INCIDENT TO ARREST	Impound of vehicle	Vehicle	6	Custodial Arrest without warrant	13219.0	245(A)(1) PC - ADW NOT FIREARM (F) 13219
8	2454	2018-07-01	00:33:19	3	0	SAN DIEGO	826	Colina Del Sol 826	NaN	estrella	NaN	4100	NaN	NaN	CA0371100	SD	2	Gang enforcement	4	1	30	1	Male	Male	No	Black/African American	None	54099	4000(A) VC - NO REG:VEH/TRAILER/ETC (I) 54099	Traffic Violation	Non-moving Violation, including Registration Violation	Pursuit of justice	None	NaN	NaN	NaN	NaN	NaN	1	No Action	0.0	NaN
9	2455	2018-07-01	00:11:00	20	1	SAN DIEGO	122	Pacific Beach 122	NaN	hornblend st	NaN	1100	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	3	1	28	1	Male	Male	No	Black/African American	None	53072	415(1) PC - FIGHT IN PUBLIC PLACE (M) 53072	Reasonable Suspicion	Matched suspect description	matched desc suspect seen fighting	Handcuffed or flex cuffed	NaN	NaN	NaN	NaN	NaN	6	Custodial Arrest without warrant	64005.0	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005

Last rows

	stop_id	date_stop	time_stop	stop_duration	address_city	beat	beat_name	highway_exit	address_street	intersection	address_block	landmark	school_name	ori	agency	officer_assignment_key	assignment	exp_years	pid	perceived_age	gender2	perceived_gender	gender	perceived_lgbt	race	disability	reason_for_stop_code	reason_for_stop_code_text	reason_for_stop	reason_for_stop_detail	reason_for_stop_explanation	action	consented	basis_for_search	basis_for_search_explanation	basis_for_property_seizure	type_of_property_seized	result_key	result	code	result_text
356196	324687	2020-06-30	19:40:00	120	SAN DIEGO	826	Colina Del Sol 826	NaN	EL CAJON BOULEVARD	NaN	5200	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	5	1	50	1	Male	Male	No	Black/African American	None	12004	211 PC - ROBBERY (F) 12004	Reasonable Suspicion	Matched suspect description	SUBJECT MATCHED THE DESCRIPTION OF THE SUSPECT GIVEN BY THE VICTIMS	Handcuffed or flex cuffed	NaN	NaN	NaN	NaN	NaN	6	Custodial Arrest without warrant	12004.0	211 PC - ROBBERY (F) 12004
356197	324690	2020-06-30	23:25:00	10	SAN DIEGO	999	Unknown 999	NB 805 AT PLAZA BLVD	NaN	NaN	0	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	15	1	22	1	Male	Male	No	Hispanic/Latino/a	None	54303	22349(A) VC - EXCEED SPEED ON HIGHWAY (I) 54303	Traffic Violation	Moving Violation	MAX SPEED 65 MPH	None	NaN	NaN	NaN	NaN	NaN	3	Citation for infraction	54303.0	22349(A) VC - EXCEED SPEED ON HIGHWAY (I) 54303
356198	324691	2020-06-30	23:50:00	12	SAN DIEGO	999	Unknown 999	NB I-15 AT I-8	NaN	NaN	0	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	15	1	25	1	Male	Male	No	Hispanic/Latino/a	None	54303	22349(A) VC - EXCEED SPEED ON HIGHWAY (I) 54303	Traffic Violation	Moving Violation	MAX SPEED 65 MPH	None	NaN	NaN	NaN	NaN	NaN	2	Warning (verbal or written)	54303.0	22349(A) VC - EXCEED SPEED ON HIGHWAY (I) 54303
356199	324697	2020-06-30	11:41:32	120	SAN DIEGO	611	Midway District 611	NaN	laning road	NaN	2500	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	1	1	40	1	Male	Male	Yes	Hispanic/Latino/a	None	53074	415(3) PC - OFFENSIVE WORDS:PUBLIC PL (M) 53074	Reasonable Suspicion	Matched suspect description	subject matched description of a radio call regarding a disturbance at a hotel	Handcuffed or flex cuffed	NaN	NaN	NaN	NaN	NaN	8	Noncriminal transport or caretaking transport	0.0	NaN
356200	324701	2020-06-30	22:38:42	12	SAN DIEGO	712	San Ysidro 712	NaN	e san ysidro	NaN	700	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	1	1	34	1	Male	Male	No	Black/African American	None	22004	459 PC - BURGLARY (F) 22004	Reasonable Suspicion	Matched suspect description	burglary call	Handcuffed or flex cuffed	NaN	NaN	NaN	NaN	NaN	1	No Action	0.0	NaN
356201	324712	2020-06-30	23:34:00	20	SAN DIEGO	514	Sherman Heights 514	NaN	25th	NaN	100	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	1	1	42	1	Male	Male	No	Hispanic/Latino/a	None	0	NaN	Investigation to determine whether the person was truant	NaN	call for service regarding setting off fireworks	Curbside detention	NaN	NaN	NaN	NaN	NaN	1	No Action	0.0	NaN
356202	324712	2020-06-30	23:34:00	20	SAN DIEGO	514	Sherman Heights 514	NaN	25th	NaN	100	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	1	2	22	1	Male	Male	No	Hispanic/Latino/a	None	0	NaN	Investigation to determine whether the person was truant	NaN	call for service regarding setting off fireworks	Curbside detention	NaN	NaN	NaN	NaN	NaN	1	No Action	0.0	NaN
356203	324712	2020-06-30	23:34:00	20	SAN DIEGO	514	Sherman Heights 514	NaN	25th	NaN	100	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	1	3	30	1	Male	Male	No	Hispanic/Latino/a	None	0	NaN	Investigation to determine whether the person was truant	NaN	call for service regarding setting off fireworks	Curbside detention	NaN	NaN	NaN	NaN	NaN	1	No Action	0.0	NaN
356204	324715	2020-06-30	15:25:00	11	SAN DIEGO	723	Otay Mesa West 723	NaN	NaN	5 south / sr-54	0	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	11	1	30	1	Male	Male	No	Hispanic/Latino/a	None	54181	21755 VC - USE SHOLDER/ETC:PAS RIGHT (I) 54181	Traffic Violation	Moving Violation	drive on right shoulder	None	NaN	NaN	NaN	NaN	NaN	3	Citation for infraction	54181.0	21755 VC - USE SHOLDER/ETC:PAS RIGHT (I) 54181
356205	324716	2020-06-30	15:45:00	12	LA MESA	999	Unknown 999	NaN	NaN	sr-125 north / 94 mege	0	NaN	NaN	CA0371100	SD	1	Patrol, traffic enforcement, field operations	11	1	26	1	Male	Male	No	White	None	54655	23123.5 VC - NO HND HLD DEVICE W/DRIVE (I) 54655	Traffic Violation	Moving Violation	cell phone	None	NaN	NaN	NaN	NaN	NaN	3	Citation for infraction	54655.0	23123.5 VC - NO HND HLD DEVICE W/DRIVE (I) 54655

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Dash Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories